ࡱ> mo$  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklpqrstuvwxyz{|}~Root Entry F/01M dnUWorkbook(_VBA_PROJECT_CUR" WMאXMMsoDataStore#!WM@WMKHQWW21==2WMWMItem PropertiesO5RZYCXSXBQ==2WM@WMItem  .PropertiesCtls VBA@WMWM \p WEB SUPPORT Ba=  ThisWorkbook= P8X@"1BCalibri1BCalibri1BCalibri1BCalibri1BCalibri1BCalibri1( B Trebuchet MS1 BCalibri1BCalibri1BCalibri1 BCalibri1BCalibri1BCalibri1BCalibri1 BCalibri1 BCalibri1 BCalibri1BCalibri1 BCalibri1BCalibri14BCalibri1 BCalibri1BCalibri1BCalibri1,8BCalibri18BCalibri18BCalibri1>141<BCalibri1?BCalibri1h8BCambria1BCalibri1 BCalibri1 BCalibri1 BCalibri1BCalibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)3" "\ #,##0;" "\ \-#,##0=" "\ #,##0;[Red]" "\ \-#,##0?" "\ #,##0.00;" "\ \-#,##0.00I"" "\ #,##0.00;[Red]" "\ \-#,##0.00u8_ " "\ * #,##0_ ;_ " "\ * \-#,##0_ ;_ " "\ * "-"_ ;_ @_ .)_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ @_ " "\ * #,##0.00_ ;_ " "\ * \-#,##0.00_ ;_ " "\ * "-"??_ ;_ @_ 61_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ 0.050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-0.00;[Red]0.00"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                       ff + ) , *       P  P         `                          ! a> " !" !  !"       ! @ @ @ @ 1@ @ !"     ( # $  "(X          1 1 !1 1        1  1  ""  @@   @  @@  @   @  ! !  !@ @  %@ @ + ||xGI}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-} 00_)}-} 00_)}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0."\ * _ ;_ }}* 00_)[$ -???##0.???"\ * ???_ ;_ ???}-}+ 00_)}-}, 00_)}-}- 00_)}-}. 00_)}-}1 00_)}A}2 a00_)[$ -}A}3 00_)[$ -}A}4 00_)?[$ -}A}5 00_)23[$ -}-}6 00_)}}8 ??v00_)̙[$ -##0."\ * _ ;_ }A}9 }00_)[$ -}A}: e00_)[$ -}-}A 00_)}}B 00_)[$ -##0."\ * _ ;_ }}C 00_)[$ -##0."\ * _ ;_ }x}D00_)[$## "\ _ }}E ???00_)[$???## ???"\  ???_ ;_ ???}-}F 00_)}-}G 00_)}U}H 00_)[$## }-}I 00_)}A}J 00_)[$}A}K 00_)[$}A}L 00_)[$}-}M 00_)}-}N 00_)}-}P 00_)}-}Q 00_)}A}U 00_)[$}(}V00_)}(}W00_)}-}X 00_)}(}Y 00_)}(}Z 00_)}-}[ 00_)}-}_ 00_)}-}` 00_)}-}a 00_)}-}b 00_)}-}c 00_)}-}d 00_)}-}e 00_)}-}f 00_)}-}g 00_)}-}h 00_)}-}i 00_)}-}j 00_)}-}k 00_)}A}o 00_)[$}A}p 00_)[$}A}q 00_)[$}A}r 00_)[$}A}s 00_)[$}-}t 00_)}-}u 00_)}A}v 00_)[$}A}w 00_)4[$ 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Excel Built-in Normal 20Excel Built-in Normal 2 21Explanatory TextG5Explanatory Text % 2Good;Good  a%3 Heading 1G Heading 1 I}%O4 Heading 2G Heading 2 I}%?5 Heading 3G Heading 3 I}%236 Heading 49 Heading 4 I}%7( Hyperlink 8InputuInput ̙ ??v% 9 Linked CellK Linked Cell }% :NeutralANeutral  e%3Normal % ;Normal 2< Normal 2 2= Normal 2 3 >Normal 3 ?Normal 4 @Normal 5 ANormal 67Normal 6 % BNoteb Note   CNote 2fNote 2   DNote 2 2jNote 2 2   EOutputwOutput  ???%????????? ???F$Percent GTitle1Title I}% HTotalMTotal %OOI Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`­Read Me Investor Details Error#Sheet3& Country_State_District_Mapping2 AndamanandNicobarIslands;' AndhraPradesh; * ArunachalPradesh; Assam; Bihar;% Chandigarh:& Chhattisgarh;! Country;&DadarNagarHaveli: % DamanandDiu;  Delhi;  Goa; ! Gujarat; ! Haryana;) HimachalPradesh;  India;$+Investment_Litigation:,8InvestmentLitigatio):,;,,. InvestmentLitigation;,,2 InvestmentLtg):,;,,( InvestmentType; '') JammuandKashmir;# Jharkhand;# Karnataka;  Kerala; ! Lakshadweep:' MadhyaPradesh;2% Maharashtra;#! Manipur; # Meghalaya;! Mizoram;NA:+" Nagaland;   Orissa;! Pondicherry:  Punjab;# Rajasthan;! sf;-- sfusa;-->$ shares_from_unpaind_suspense_account;--Asharesfromunpaidsuspenseaccountz-{--$ sharesfusa;--  Sikkim; ss;-- sss;--# TamilNadu; # Telangana; !!! Tripura;""% Uttarakhand; $$& UttarPradesh;K##$ WestBengal;%%gfffP0%$@  82O) "<<ɴb#:|1E@=<<ɴb#:|1E ge6xVMKTa~uJf,@(3!lWQDj L`.M0DТHiE? ܄$AVHjQ&>n{f.&g|=}ܫ@͐4f`*t^x(b6bovO=㎽Ps`őK4--QqRJFuq'5B ks3Z~r'SI3rncT`&(Ku! ȅȳycyW\YYx m SrnnnV<13^Ig\x<'#8*\=_1{buJ?o:R3OFyGx58 zZځT]죎dMYO ~zACs41Ko0Y%DؐCrI"fVɲQ *WqrHjr)O-9Ww N{WuPta Wՠjr(H^N>dz(򾱱&'z,ɳՋ-zo>Ϫǽ*茗^9͔`M.KԒ_3ztF̑Irf?~ Dz\@Лd_KS ݿUV9e^|+|*C_^.>7ɗN 0ӧ{),r7R܍>ܱ37?=ɫN36>,0-w'.D̕<:E^{,ͳ~Òq"K"xG|ycʍfVW 'hCv$?{n|;b+Y e[>xcƴ={Ɛ8D & ,1\N\.ݟrՕ\Y\YJuR(b#¸;.̴ʺ*$ʲ݈z9޿gp?>E<60?xR$V}tz>\\ktߎYjS_?-n=I[y2Њ~ +uJ|˦әrFcV0Łoq_#n=pn݄]:x&*33e}`{#sQ H|H\y*ӆ5~ըp~os:NWVyɡ wkReWOHի٬JǕLFXG\56FMjR2SG1xE_OME^^`MeSG?[>)B㫜. ԓ_3zxM` uC~" H|mICkg=DJP9u^lI| eoo~.'gg4(weAήeǓ齛"ϋ-ץ] ~l~}%nHdez8Z^g0wۓyvceɱ wg6UR!~c8-"#؎~uOJ4sc$ DJCh5(_WPPEUDY8*;zV˚ۀC) :3 A@@   .[Read the following instructions carefully before proceeding to enter the Investor Details: Important Note >Steps to follow to fill details in the 'Investor Details' tab. Enable MacrosY It is important that you Enable Macro using following instructions : a) Excel 2000 and 2003: Tools-->Macro-->Security-->Select 'Low'-->OK b) Excel 2007: Office Button-->Excel Options-->Trust Center-->Trust Center Settings--Macro Settings-->Enable all Macros-->OK Pl Note : Close the Excel Sheet and re-open it after enabling Macro to start.  Enter the CIN  Add Investor DetailsSave the Excel file If you have multiple excels for the same CIN and SRN; use the below nomenclature: (ABC_1.xls, ABC_2.xls,ABC_3.xls ...) where ABC represents the CIN of the Company Upload the Excel fileCountry Indian StatesAndaman and Nicobar IslandsAndhra PradeshArunachal PradeshAssamBihar Chandigarh ChhattisgarhDadar Nagar Haveli Daman and DiuDelhiGoaGujaratHaryanaHimachal PradeshJammu and Kashmir Jharkhand KarnatakaKerala LakshadweepMadhya Pradesh MaharashtraManipur MeghalayaMizoramNagalandOrissa PondicherryPunjab RajasthanSikkim Tamil Nadu TelanganaTripura Uttar Pradesh Uttarakhand West BengalInvestment TypeNAINDIAAndaman Islands AnantapurAnjawBarpetaArariaBastarDadar & Nagar HaveliDaman Central Delhi North Goa AhmedabadAmbalaBilaspurAnantnagBokaroBagalkot Alappuzha Alirajpur Ahmednagar BishnupurEast Garo HillsAizawlDimapurAngulAmritsarAjmer East SikkimAriyalurAdilabadDhalaiAgraAlmoraBankura(Amount for unclaimed and unpaid dividend AFGHANISTANNicobar IslandsChittoor Changlang Bongaigaon AurangabadDiu South GoaAmreliBhiwaniChambaBadgamChatraBangalore Rural ErnakulamAnuppurAkola ChurachandpurEast Khasi HillsChamphaiKiphire Boudh (Bauda)BarnalaAlwar West SikkimChennai North TripuraAligarh Bageshwar BardhamanAmount for matured deposits ALAND ISLANDS East Godavari Dibang ValleyCacharBanka Dantewada East DelhiAnand FaridabadHamirpurBaramulaDeogharBangalore UrbanIdukki AshoknagarAmravatiChandel Jaintia HillsKolasibKohimaBhadrakBathindaBanswara North Sikkim Coimbatore Hyderabad South Tripura AllahabadChamoliBirbhumAmount for matured debenturesALBANIAGuntur East KamengDarrang BegusaraiDhamtari New Delhi Banas Kantha FatehabadKangraDodaDhanbadBelgaumKollamBalaghat Imphal EastRi-Bhoi LawngtlaiLonglengBolangir (Balangir)FaridkotBaran South Sikkim Cuddalore Karimnagar West TripuraAmbedkar Nagar Champawat Cooch Behar+Amount for application money due for refundALGERIAKadapa East SiangDhemaji BhagalpurDurg North DelhiBharuchGurgaonKinnaurJammuDumkaBellaryKannurBarwaniBeed Imphal WestSouth Garo HillsLunglei Mokokchung Baleswar (Balasore)Fatehgarh SahibBarmer DharmapuriKhammamAuraiyaDehradun DarjeelingInterest on matured debenturesAMERICAN SAMOAKrishna Kurung KumeyDhubriBhojpurJanjgir-Champa North East BhavnagarHissarKuluKargilGarhwaBidar KasaragodBetulBhandaraSenapatiThe West Khasi HillsMamitMonBargarh (Baragarh)Fazilka BharatpurDindigul MahbubnagarAzamgarhHaridwarEast MidnaporeInterest on matured depositsANDORRAKurnoolLohit DibrugarhBuxarJashpur North WestDahodJhajjarLahaul and SpitiKathuaGiridihBijapurKottayamBhindBuldhana TamenglongWest Garo HillsSaihaPerenCuttackFirozpurBhilwaraErodeMedakBadaunNainitalHooghly,Interest on application money due for refundANGOLAPrakasamLower Dibang ValleyGoalpara DarbhangaKanker South Delhi GandhinagarJindMandiKupwaraGoddaChamarajanagar KozhikodeBhopal ChandrapurThoubalSerchhipPhekDebagarh (Deogarh) GurdaspurBikaner KanchipuramNalgondaBagpat Pauri GarhwalHowrah&Redemption amount of preference sharesANGUILLANellore Papum PareGolaghatEast ChamparanKawardhaSouth West DelhiJamnagarKaithalShimlaLehGumla Chikballapur Malappuram BurhanpurDhuleUkhrulTuensang Dhenkanal HoshiarpurBundi Kanyakumari NizamabadBahraich Pithoragarh Jalpaiguri#Sales proceed for fractional shares ANTARCTICA SrikakulamTawang HailakandiGayaKorba West DelhiJunagadhKarnalSirmaurPoonch Hazaribagh ChikmagalurPalakkad Chhatarpur GadchiroliWokhaGajapati Jalandhar ChittorgarhKarur Rangareddi Balarampur Rudra PrayagKolkataANTIGUA AND BARBUDAVishakhapatnamTirapJorhat GopalganjKoriyaKachchh KurukshetraSolanPulwamaJamtara ChitradurgaPathanamthitta ChhindwaraGondia ZunhebotoGanjam KapurthalaChuru KrishnagiriWarangalBallia Tehri GarhwalMalda ARGENTINA Vizianagaram Upper SiangKamrupJamui MahasamundKheda MahendragarhUnaRajauriKodermaDakshina KannadaThrissurDamohHingoli JagatsinghpurLudhianaDausaMaduraiBandaUdham Singh Nagar MurshidabadARMENIA West GodavariUpper Subansiri Karbi Anglong JehanabadRaigarhMahesanaMewatSrinagarLatehar DavanagereThiruvananthapuramDatiaJalgaonJajapur (Jajpur)MansaDholpur Nagapattinam Barabanki UttarkashiNadiaARUBA West Kameng KarimganjKaimurRaipurNarmada PanchkulaUdhampur LohardagaDharwadDewasJalna JharsugudaMoga DungarpurNamakkalBareillyNorth 24 Parganas AUSTRALIA West Siang KokrajharKatihar RajnandgaonNavsariPanipatPakurGadagDharKolhapur KalahandiMuktsar Hanumangarh PerambalurBastiNorth DinajpurAUSTRIA LakhimpurKhagariaSurguja Panch MahalsRewariPalamuGulbargaDindoriLatur Kandhamal PathankotJaipur PudukkottaiBhimnagar (Sambhal)Purulia AZERBAIJANMarigaon KishanganjPatanRohtakPashchim SinghbhumHassanGuna Mumbai City KendraparaPatiala JaisalmerRamanathapuramBijnorSouth 24 ParganasBAHAMASNagaon Lakhisarai PorbandarSirsaPurba SinghbhumHaveriGwaliorMumbai SuburbanKendujhar (Keonjhar)RupnagarJalorSalem BulandshahrSouth DinajpurBAHRAINNalbari MadhepuraRajkotSonepatRanchiKodaguHardaNagpurKhordha!Sahibzada Ajit Singh Nagar-MohaliJhalawar Sivaganga ChandauliWest Midnapore BANGLADESHNorth Cachar Hills Madhubani Sabar Kantha Yamuna Nagar SahibganjKolar HoshangabadNandedKoraputSangrur Jhunjhunu Thanjavur!Chhatrapati Shahuji Maharaj NagarBARBADOSSibsagarMungerSurat SeraikelaKoppalIndore Nandurbar MalkangiriShahid Bhagat Singh NagarJodhpurTheni ChitrakootBELARUSSonitpur Muzaffarpur SurendranagarSimdegaMandyaJabalpurNashik MayurbhanjKarauli The NilgirisDeoriaBELGIUMTinsukiaNalanda The DangsMysoreJhabua Osmanabad NabarangpurKotaThirupurEtahBELIZENawadaVadodaraRaichurKatniParbhaniNayagarhNagaur ThiruvallurEtawahBENINPatnaValsad RamanagaraKhandwaPuneNuapadaPaliThiruvannamalaiFaizabadBERMUDAPurniaShimogaKhargoneRaigadPuri Pratapgarh Thiruvarur FarrukhabadBHUTANRohtasTumkurMandla RatnagiriRayagada Rajsamand ThoothukudiFatehpurBOLIVIASaharsaUdupiMandsaurSangli SambalpurSawai MadhopurTiruchirapalli FirozabadBOSNIA AND HERZEGOVINA SamastipurUttara KannadaMorenaSataraSubarnapur (Sonepur)Sikar TirunelveliGautam Buddha NagarBOTSWANA< SaranYadgir Narsinghpur SindhudurgSundargarh (Sundergarh)SirohiVellore Ghaziabad BOUVET ISLAND SheikhpuraNeemuchSolapurSri Ganganagar ViluppuramGhazipurBRAZILSheoharPannaThaneTonk VirudhunagarGondaBRITISH INDIAN OCEAN TERRITORY SitamarhiRaisenWardhaUdaipur GorakhpurBRUNEI DARUSSALAMSiwanRajgarhWashimBULGARIASupaulRatlamYavatmalHardoi BURKINA FASOVaishaliRewaJalaunBURUNDIWest ChamparanSagarJaunpurCAMBODIASatnaJhansiCAMEROONSehoreJyotiba Phule NagarCANADASeoniKannauj CAPE VERDEShahdol Kanpur DehatCAYMAN ISLANDSShajapur Kanpur NagarCENTRAL AFRICAN REPUBLICSheopurKanshiram NagarCHADShivpuri KaushambiCHILESidhi KushinagarCHINA SingrauliLakhimpur KheriCHRISTMAS ISLAND TikamgarhLalitpurCOCOS (KEELING) ISLANDSUjjainLucknowCOLOMBIAUmariaMahamaya NagarCOMOROSVidisha MaharajganjCONGOMahoba COOK ISLANDSMainpuri COSTA RICAMathura COTE DIVOIREMauCROATIAMeerutCUBAMirzapurCYPRUS MoradabadCZECH REPUBLIC Muzaffarnagar$DEMOCRATIC PEOPLES REPUBLIC OF KOREAPanchsheel Nagar (Hapur)DENMARKPilibhitDJIBOUTIPrabuddha Nagar (Shamli)DOMINICADOMINICAN REPUBLIC RaebareliECUADORRampurEGYPT Saharanpur EL SALVADORSant Kabir NagarEQUATORIAL GUINEASant Ravidas NagarERITREA ShahjahanpurESTONIA ShravastiETHIOPIASiddharthnagarFALKLAND ISLANDS (MALVINAS)Sitapur FAROE ISLANDS SonbhadraFEDERATED STATES OF MICRONESIA SultanpurFIJIUnnaoFINLANDVaranasiFRANCE FRENCH GUIANAFRENCH POLYNESIAFRENCH SOUTHERN TERRITORIESGABONGAMBIAGEORGIAGERMANYGHANA GIBRALTARGREECE GREENLANDGRENADA GUADELOUPEGUAM GUATEMALAGUERNSEYGUINEA GUINEA-BISSAUGUYANAHAITI!HEARD ISLAND AND MCDONALD ISLANDSHOLY SEE (VATICAN CITY STATE)HONDURAS HONG KONGHUNGARYICELAND INDONESIAIRAQIRELANDISLAMIC REPUBLIC OF IRAN ISLE OF MANISRAELITALYJAMAICAJAPANJERSEYJORDAN KAZAKHSTANKENYAKIRIBATIKOREAKUWAIT KYRGYZSTANLAO PEOPLES DEMOCRATIC REPUBLICLATVIALEBANONLESOTHOLIBERIALIBYAN ARAB JAMAHIRIYA LIECHTENSTEIN LITHUANIA LUXEMBOURGMACAO MADAGASCARMALAWIMALAYSIAMALDIVESMALIMALTAMARSHALL ISLANDS MARTINIQUE MAURITANIA MAURITIUSMAYOTTEMEXICOMONACOMONGOLIA MONTENEGRO MONTSERRATMOROCCO MOZAMBIQUEMYANMARNAMIBIANAURUNEPAL NETHERLANDSNETHERLANDS ANTILLES NEW CALEDONIA NEW ZEALAND NICARAGUANIGERNIGERIANIUENORFOLK ISLANDNORTHERN MARIANA ISLANDSNORWAYOMANPAKISTANPALAUPALESTINIAN TERRITORYPANAMAPAPUA NEW GUINEAPARAGUAYPERU PHILIPPINESPITCAIRNPOLANDPORTUGAL PUERTO RICOQATARREPUBLIC OF MOLDOVAREUNIONROMANIARUSSIAN FEDERATIONRWANDASAINT BARTHELEMY SAINT HELENASAINT KITTS AND NEVIS SAINT LUCIA SAINT MARTINSAINT PIERRE AND MIQUELON SAINT VINCENT AND THE GRENADINESSAMOA SAN MARINOSAO TOME AND PRINCIPE SAUDI ARABIASENEGALSERBIASERBIA AND MONTENEGRO SEYCHELLES SIERRA LEONE SINGAPORESLOVAKIASLOVENIASOLOMON ISLANDSSOMALIA SOUTH AFRICA,SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDSSPAIN SRI LANKASUDANSURINAMESVALBARD AND JAN MAYEN SWAZILANDSWEDEN SWITZERLANDSYRIAN ARAB REPUBLICTAIWAN TAJIKISTANTHAILAND THE DEMOCRATIC REPUBLIC OF CONGO)THE FORMER YUGOSLAV REPUBLIC OF MACEDONIA TIMOR-LESTETOGOTOKELAUTONGATRINIDAD AND TOBAGOTUNISIATURKEY TURKMENISTANTURKS AND CAICOS ISLANDSTUVALUUGANDAUKRAINEUNITED ARAB EMIRATESUNITED KINGDOMUNITED REPUBLIC OF TANZANIA$UNITED STATES MINOR OUTLYING ISLANDSUNITED STATES OF AMERICAURUGUAY UZBEKISTANVANUATU VENEZUELAVIET NAMVIRGIN ISLANDSWALLIS AND FUTUNAWESTERN SAHARAYEMENZAMBIAZIMBABWECIN Company NameNominal value of sharesInvestor First NameInvestor Middle NameInvestor Last NameFather/Husband First NameFather/Husband Middle NameFather/Husband Last NameAddressStateDistrictPin Code Folio NumberDP Id-Client Id-Account NumberNumber of shares (i)Install the pre-requisite softwares to proceed. The path for the same is as follows: MCA Portal >> Investor Services >> IEPF >> IEPF Application >> Prerequisite Software (ii) Upload the excel file in the format xls only (iii) Do not make any changes in the excel format/sheet name. Also do not delete any tab/sheet in the file PLEASE NOTE: 1) Kindly ensure that Summation of amounts in the excel(s) should be equal to that in IEPF Form, else your excel shall get rejected. 2) Kindly ensure that AGM Date in the excel(s) should be same as in IEPF Form, else your excel shall get rejected.   (i) Enter the CIN in the excel (cell B2) (ii) Click on "Prefill" button (iii) Company Name will be automatically filled on click of prefill button . User need not enter it. 9 B ] z U Path to upload the excel file is HOME -> IEPF SERVICES -> Upload Investor details. -Actual Date of transfer to IEPF (DD-MON-YYYY) Note: This sheet is applicable for uploading the particulars related to the shares transferred to Investor Education and Protection Fund. Make sure that the details are in accordance with the information already provided in e-form IEPF-4.PAN Aadhar Number Nominee NameJoint Holder NameRemarks6Is the Investment (amount/shares) under any litigation3Is the shares transfer from unpaid suspense accountInvestment LitigationYESNOYES $shares from unpaind suspense account (i) Fill in the required details in Columns A to P for Investor Details (row 15 onwards) (ii) Follow the below mentioned validations for filling in the details. First Name -> Mandatory if 'Last Name' is blank and Length should be less or equal to 35 characters. Middle Name -> Length should be less or equal to 35 characters. Investor Last Name -> Mandatory if 'First Name' is blank and Length should be less or equal to 35 characters. Father/Husband First Name -> Mandatory if 'Father/Husband Last Name' is blank and Length should be less or equal to 35 characters. Father/Husband Middle Name -> Length should be less or equal to 35 characters. Father/Husband Last Name -> Mandatory if 'Father/Husband First Name' is blank and Length should be less or equal to 35 characters. Address -> Mandatory and Length should be less or equal to 300 characters. Country -> Mandatory and Select value from the dropdown. State -> Mandatory and Select value from the dropdown. (1)If the Country is  INDIA , the state should Indian state (2)If the Country is other than INDIA state should be  NA . District -> Select value from the dropdown. (1)If th< e Country is  INDIA , the district should be Indian districts corresponding to the State selected in dropdown. (2)If the Country is other than INDIA district will be  NA Pin code -> Alphanumeric and Length should be eithe 6 or 12 dight Folio Number -> Mandatory and Length should be less than or equal to 20 characters. Investment Type -> Select value from the dropdown. Amount Due -> Mandatory and should be greater than zero. Date of Event-> should be in DD-MON-YYYY format where 'MON' implies first three letters of Month. PAN -> Alphanumeric and Should be equal to 10 characters Date of Birth -> Should be in DD-MON-YYYY format where 'MON' implies first three letters of Month. Aadhar Number -> Should be exactly 12 digits. Nominee Name -> Length should be less than or equal to 100 characters. Joint Holder Name -> Length should be less than or equal to 100 characters. Remarks -> Length should be less than or equal to 100 characters. Is the Investment (amount / shares )under any litigation. -> Mandatory and select value from Dropdown Is the shares transfer from unpaid suspense account (Yes/No) -> Mandatory and select value from Dropdown (iii) Click on "Validate" button (iii) Details of the Errors will be shown in "Error" Sheet. *Make sure that Error sheet contains no errors. % H `  Date of Birth(DD-MON-YYYY) L74899DL1960GOI00333551Թ (INDIA) LIMITEDOMPARKASHJAINKL+A-46 RAM DUTT ENCLAVE UTTAM NAGAR NEW DELHI110059DPID-CLID-1203320000596801RAKESHAGGARWALLAXMINARAINAGARWALLH NO A-2158 GROUND FLOOR BACK SIDE GATE NO - 5 GREEN FIELDS COLONY FARIDABAD121003DPID-CLID-1206070000008662RINASINHAKAMTAPRASAD/C/O RAJESH KUMAR SINHA MOHANPUR PACHAMBA GIRDIH815301DPID-CLID-IN30177411871070BHOJAKPUNAM HARSHADKUMAR NATAVARLALNAYAK,16 KHATA COLONY NAVAVADAJ VADAJ 64 AHMEDABAD380013DPID-CLID-IN30290241298342 17-NOV-2021 05-AUG-1945 22-MAR-1972 RAJRANIJAIN 30-OCT-2021L[ ]$__E_O``s aoa/a#bb\bUcct-ddB d Fe eq f kf+ f Ng gY h h? h 6i iSiWjjn!kkGk;llsmkm+m9nnTnYoovplp,p'qqGqDrrXrHsshsbt"t$uuQuOvvwwDwIx x^x>y6z{:||}~<:'[SGzك}BO  [ U  2 e f [ h g !^+   : ǨH ccBĘ7ɹq1   F  dMbP?_*+%,&ffffff?'ffffff?(?)?MR\\HYDHTCPRNTSRV02\HYDHTCB18F01tC odXXLetterDINU"0 D  0SMTJ IUPH"xjAM4Q"a` jźM&XXnkKLnۃR^}x+H}gd$?Ő,|v|)^E*RX Ikew][~*_^^a&j#~X>S&&)/M;~a$d)'*3ӽm(w{. )6>@B|UeM)=w_ӫj%m-sK _a]A ҉}EYD _ o&,AF ݪM?ky/n?|4EU ;X'K[nSVA= sx.e%*XaZL #3J˯Vkv%g;KV˭Gzl~޿.u>:b.:}-   F&]W$~z" dXX333333?333333?&<3cU} I'X} I|X} X Y  [ J,  ll Y Z mn \ ] Y ] Y ] ^ ] \ ZPH0(  >@ Sheet4gg  $m_  dMbP?_*+%,&ffffff?'ffffff?(?)?MSend To OneN  !"#$%&'()*+,./0123456789:;<=>?2iwDocumentLibraryFormDocumentLibraryFormDocumentLibraryFormote 16@/ odXXLetterGIS4DINU"$SMTJ{3EE39114-30B4-45a4-A109-19D4A40FCC22}RESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITResolutionDPI600ColorMode24bppV4DM" dXX333333?333333?&<3cU} ma} ma} a} ma} a} $_} _} $_} d} a} a} e} $`} ma} I _} ma} a} $_} _}  _} $_} _} $ _} _} $ _P,P,P,P,P,P,P,PP ,    ,,,,,,,,,,,,,,,,,,, wwwwwwwwwwwww Q op Q q rs c b t ttu~ v@v b b b b b R R R R R R R R R  R  T  R  R  R S T T T T T T T T Tg h h h h h h h h2 h hE h h h h$@i$@ j a _ _ _~ f@ a a a a a a a _2 _ _| d a a eI@`I@ j a _ _ a a a a a a a _2 _ _ d a a eT@`T@ k _ _ a a a a a a a _2 _ _= d a a eh@`h@ k _ _ jjfjjjjjjjjjjjjjjjjjD l0Z @ Z    ,!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?, j!j"j#j$j%j&j'j(j)j*j+j,j-j.j/j0j1j2j3j4j5j6j7j8j9j:j;j<j=j>j?jDl @,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,[,\,],^,_,@jAjBjCjDjEjFjGjHjIjJjKjLjMjNjOjPjQjRjSjTjUjVjWjXjYjZj[j\j]j^j_jDl `,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,{,|,},~,,`jajbjcjdjejfjgjhjijjjkjljmjnjojpjqjrjsjtjujvjwjxjyjzj{j|j}j~jjDl ,,jj< :# 1"#(    l A ?@AA?CommandButton15 ]`@M1 6$ODForms.CommandButton.1H"  s HA ?@CommandButton2"ÊPK!4xP[Content_Types].xmlN0EH-J@5XIbl$M$J7Xܹc/W;kc|QV^icRs28;_5W>`bv}A${JQBcD۪һ.y1=(| P7X\A?IED$2Ml:*&cMuH7Ð`ҽ0V!WD.CTBEѦy(7=AVKT^n,Ͱ:3qyl3?4?PK!0?2 _rels/.rels 0nzUd$dۛ xeof1Fw AN{c]t- 838zG 6Y}S~XRHz \v:'L /ؓ\JO4_L7 T ϐ}YM[#B,#1цhEU Z~-m^PK!clipboard/drawings/drawing1.xmlN0H4l)Dh) Z A XK-o8qKBgx/J;/(kfjۊ}qJkFrO/Pl'A%T YY#cF_cGfHV2+$S 4 Y94 =xDJV$} o}K~鈨+ӠE4KlUX7Nx4d]x#1-~9:I>R_NbuXCJ# ~)~ŦQ *'OrDE忼,`1.SۇRk!e4G1bCWapK}'ĕ\=sS'>8X6eT+˧_ :nQ$ O6!C Gf !iaoPK!SRa*clipboard/drawings/_rels/drawing1.xml.relsJ1 Prكlg/"UmS⾽ս8K qU\jHb`(\o|6Gk6p f+~T#b G:eSz[MԯN&I(!}y{ڃC"$qǫ^x>8xwFK xL:ޜH]>ɘc1$"rwPdcmM@2OH Ϧ\DX&*ZimGfCP#~{:>1ɴ#пų<9G#@yaAǫ?omH1bma)q.:hl e\9?Z]<j7Ye޽Jp%nNuL ^6Vc KFwk9x~pjx :A=L9)|(Ȇ<)ժ\}.@'d}Ƃb-o\xbI\"iYH&}+@^='?ѣ?Z^Ņ/ϯ?Fٓ_}wK[DfjN|+F! }:[sp]:ﮀQ>: L7rκ\:UhŬLvNhf{!qc8V8 1QH?XwRǯ\B(bZ;XC#˼fݻYEBA`V0ǍLᨌGXeJ/RA8Oekn UiwV/43HKv@AZ'KɤYYצZY_=lY}NgÙ+Ωŋtvaזٓ% iv1)4>(A|VӴ|ga~xEF疒caQ3LFiA_N˝P&JT/~PK !#@4FFclipboard/media/image1.pngPNG  IHDR.¸sRGBgAMA a pHYs&?IDATx^q0@QT6 M(rf"X78 I,Q6qض-pAP!BB *"T D@P!BBf16&>;E}W>GnM3皏I/!V&.+⯒8[(L jɇZ)qD_ߪ]8\ R&>G\:? !/91boD;6ۚ q]l4%M|S<#Ĩ ʭ]8!x5D譨_wѷSOhԇ?LbBmLxSosֶM)ѷ;.P9!**"T D@P!BB *"TCNGz "qȲC܏IENDB`PK-!4xP[Content_Types].xmlPK-!0?2 E_rels/.relsPK-!/clipboard/drawings/drawing1.xmlPK-!SRa*'clipboard/drawings/_rels/drawing1.xml.relsPK-!Z=Aclipboard/theme/theme1.xmlPK- !#@4FFG clipboard/media/image1.pngPKZM]` M1 6$ODForms.CommandButton.1HH<"  s HA ?@CommandButton3"ÊPK!4xP[Content_Types].xmlN0EH-J@5XIbl$M$J7Xܹc/W;kc|QV^icRs28;_5W>`bv}A${JQBcD۪һ.y1=(| P7X\A?IED$2Ml:*&cMuH7Ð`ҽ0V!WD.CTBEѦy(7=AVKT^n,Ͱ:3qyl3?4?PK!0?2 _rels/.rels 0nzUd$dۛ xeof1Fw AN{c]t- 838zG 6Y}S~XRHz \v:'L /ؓ\JO4_L7 T ϐ}YM[#B,#1цhEU Z~-m^PK!clipboard/drawings/drawing1.xmlN0H4l)Dh) Z A XK-o8qKBgx/J;/(kfjۊ}qJkFrO/Pl'A%T YY#cF_cGfHV2+$S 4 Y94 =xDJV$} o}K~鈨+ӠE4KlUX7Nx4d]x#1-~9:I>R_NbuXCJ# ~)~ŦQ *'OrDE忼,`1.SۇRk!e4G1bCWapK}'ĕ\=sS'>8X6eT+˧_ :nQ$ O6!C Gf !iaoPK!SRa*clipboard/drawings/_rels/drawing1.xml.relsJ1 Prكlg/"UmS⾽ս8K qU\jHb`(\o|6Gk6p f+~T#b G:eSz[MԯN&I(!}y{ڃC"$qǫ^x>8xwFK xL:ޜH]>ɘc1$"rwPdcmM@2OH Ϧ\DX&*ZimGfCP#~{:>1ɴ#пų<9G#@yaAǫ?omH1bma)q.:hl e\9?Z]<j7Ye޽Jp%nNuL ^6Vc KFwk9x~pjx :A=L9)|(Ȇ<)ժ\}.@'d}Ƃb-o\xbI\"iYH&}+@^='?ѣ?Z^Ņ/ϯ?Fٓ_}wK[DfjN|+F! }:[sp]:ﮀQ>: L7rκ\:UhŬLvNhf{!qc8V8 1QH?XwRǯ\B(bZ;XC#˼fݻYEBA`V0ǍLᨌGXeJ/RA8Oekn UiwV/43HKv@AZ'KɤYYצZY_=lY}NgÙ+Ωŋtvaזٓ% iv1)4>(A|VӴ|ga~xEF疒caQ3LFiA_N˝P&JT/~PK !#@4FFclipboard/media/image1.pngPNG  IHDR.¸sRGBgAMA a pHYs&?IDATx^q0@QT6 M(rf"X78 I,Q6qض-pAP!BB *"T D@P!BBf16&>;E}W>GnM3皏I/!V&.+⯒8[(L jɇZ)qD_ߪ]8\ R&>G\:? !/91boD;6ۚ q]l4%M|S<#Ĩ ʭ]8!x5D譨_wѷSOhԇ?LbBmLxSosֶM)ѷ;.P9!**"T D@P!BB *"TCNGz "qȲC܏IENDB`PK-!4xP[Content_Types].xmlPK-!0?2 E_rels/.relsPK-!/clipboard/drawings/drawing1.xmlPK-!SRa*'clipboard/drawings/_rels/drawing1.xml.relsPK-!Z=Aclipboard/theme/theme1.xmlPK- !#@4FFG clipboard/media/image1.pngPKq@]` M1 6$O@Forms.CommandButton.1H> @  * M  Invalid CINPlease enter a valid CINFoomc  Input Errpr.You cannot enter Name more than 35 characters.# f  Input Error1You cannot enter Address more than 300 characters#, k  Invalid Input5Please select a valid Country from the drop-down list##   Invalid Input3Please select a valid State from the drop-down list0lINDIA  , NAB"   Invalid Input6Please select a valid District from the drop-down listL Bx" R  Inout ErrorPlease enter a valid Pin Codet th  ~  Input ErrorIFolio Number should be alphanumeric and less than or equal 20 characters.B | Input ErrorhDP Id-Client Id-Account Number should be alphanumeric and of length less than or equal to 60 characters.<   Input ErrorNPlease enter valid Number of Shares. Values can range from (1-999999999999999) e to3&k C   Input ErrorVPlease enter the proper Nominal Value of Shares ranging from 0.01 to 9999999999999.99 o{Gz? ?0B j  Input Error5Please enter the Date of Event in the required format f.0  h  Input Error3Please enter the Date of AGM in the required format    Invalid Input3Please select a valid State from the drop-down list0lINDIA  , NAB" W Invalid Value!Please select from Drop down liste #,wn + ue#,Pl R( Invalid PAN PAN should contain 10 characterst F( Invalid DateInvalid date formatch er X(Invalid Aadhar#Aadhar should contain 12 characters bx Invalid Name/Nominee Name should be less than 100 charactersdlx Invalid Name9Joint Holder Name should contain less than 100 charactersd]Invalid Remarks*Remarks should be less than 100 characterschacQ Invalid selectionplease select from drop downchacC( Invalid DateInvalid date formatomro Sheet1gg@  "  dMbP?_*+%,&ffffff?'ffffff?(?)?M2WebEx Document LoaderTC odZZLetterGISUDINU"TJjSMTJ"dZZ333333?333333?&<3U} IPH0 0(   >@ Sheet2gg  0T)NbwLܷ  dMbP?_*+%,&ffffff?'ffffff?(?)?M2WebEx Document LoaderTC odZZLetterGISUDINU"TJjSMTJ"dZZ333333?333333?&<3cU} m1M} M} $M} IM} M} $M}  M} M} M} M} M} M} M} M} M} $M} IM} M} $ M} M} mM} M} M}  M}  M} mM}  M} M} M} m M} M} !!I M} "" M} ##$ M} $$mM} %%M} &&$ M} ''+M} (*$ M} ++$M} ,,mM} --"M} .$ M..,.;.;.;.;.;.;.;., ., ., ., ., .,.,.,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, J J J J K K K K K K K K K K K K K K K K K K K K! K" K# K$ K% K& K' K( K) K* !K+ "K, #K- $K. %K/&J 'U0(J~ )L@*J +J1 ,M -M N2 N N3 N4 N5 N6 N7 N N8  N9  N:  N;  N<  N= N> N? N@ NA NB NC N1 ND NE NF NG NH NI NJ N1 NK NL NM  NN !NO "NP #NQ $NR %NS&N 'VT (NO) +M1 ,M -M NU N NV NW NX NY NZN N? N  N[  N  N\  N] N^ N_ N` Na Nb NcN Nd Ne Nf Ng Nh Ni NjN Nk Nl Nm  Nn !N "No #Np $Nq %Nr&N 'Vs (NN) ,M -M Nt NN Nu Nv Nw NxN Ny  NN  Nz N  N{ N| N} N~ N N NN N N N N N N NN N N N  N !N "N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N NZ N N N N NN N N N  N !N "N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N  N  N  N N N   NN  N N  N N N N N N NN N N NN N N NN N NN  N !N:"N #N  $N! %N"&N 'W# (NN) N$ N N N% N& N' N( N N) NN N* N N+ N, N- N. N/ N0 N1 N N2 N3 N4 NN N5 N6 N N7 N8 N N9 !NT "N #N; $N< %N= &N 'W> (NN) N? N N N@ NA NB NC N ND NN NE N NF NG NH NI NJ NK NL N NM NN NNN NO NP N NQ NR N NS !Nl "N #NU $NV %NW &NNNN) NX N N NY NZ N[ N\ N N] NNNN N^ N_ N` Na Nb Nc Nd N Ne Nf NNN Ng Nh N Ni Nj N Nk "N #Nm $Nn %No &NNNN) Np N N Nq Nr Ns Nt N Nu NN  N Nv Nw Nx Ny Nz N{ N| N N} N~ NNNN N N N N N N !NN" #N $N %N &NNNN) N N N N N N N N N NNNN N N N N N N N N N N NNNN N N N N N N !NN" #N $N %N &NNNN) N N NN N N NN N NNNN  N NN N N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NN N N NN N NNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NN N NNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$NNNNNN) N  N NNN N  N NNNNNN  N  NNN N  N NN N NNNNN NN N NN  N !NN" #N$NNNNNN) N N! NNN N NNNNNNN  N NNN N N NN N NNNNN N NN NN  N  !NN" #N!$NNNNNN) N" N" NNN N# N$NNNNNN  N%NNNN N& NN N' N(NNNN N) NN N*N  N+ !NN" #N,$NNNNNN) N- N#NNNN N.NNNNNN  N/NNNN N0 NN N1 N2NNNN N3 NN N4N  N5 !NN" #N6$NNNNNN) N7 N$NNNN N8NNNNNN  N9NNNN N: NN N; N<NNNN N= NN N>N  N? !NN" #N@$NNNNNN) NA N%NNNN NBNNNNNNNNNNN NC NN ND NENNNN NF NN NGN  NH !NN" #NI$NNNNNN) NJ N&NNNN NKNNNNNNNNNNN NL NN NM NNNNNN NO NN NPN  NQ !NN" #NR$NNNNNN) NS N'NNNN NTNNNNNNNNNNN NU NN NV NWNNNN NX NN NYN  NZ !NN" #N[$NNNNNN) N\ N(NNNN N]NNNNNNNNNNN N^ NN N_ N`NNNN Na NN NbN  Nc !NN" #Nd$NNNNNN) Ne N)NNNN NfNNNNNNNNNNN Ng NN Nh NiNNNN Nj NN NkN  Nl !NN" #Nm$NNNNNN) Nn N*NNNN No"NNNNNNNNNNNNNN Np NqNNNNNNN NrN  Ns !NN" #Nt$NNNNNN)D26lxdF rrr^RH<00 *,!*,"*,#*,$*,%*,&*,'*,(*,)*,**,+*,,*,-*,.*,/*,0*,1*,2*,3*,4*,5*,6*,7*,8*,9*,:*,;*,<*,=*,>*,?*, Nu N+ NNNN Nv" NNNNNNNNNNNNNN Nw Nx NNNNNNN Ny N Nz !NN" #N{ $NNNNNN) !N| !N,!NNNN !N}"!NNNNNNNNNNNNNN !N~ !N!NNNNNNN !N!NNNN" !#N!$NNNNNN) "N "N-"NNNN "N""NNNNNNNNNNNNNN "N "N"NNNNNNNNNNNN" "#N}"$NNNNNN) #N #N.#NNNN #N"#NNNNNNNNNNNNNN #N #N#NNNNNNNNNNNN" ##N#$NNNNNN) $N $N/$NNNN $N"$NNNNNNNNNNNNNN $N $NNNNNNNNNNNNN" $#N$$NNNNNN) %N%NNNNN %N"%NNNNNNNNNNNNNN %N %NNNNNNNNNNNNN" %#N%$NNNNNN) &N,&NNNNNNNNNNNNNNNNNNN &N &NNNNNNNNNNNNN" &#N&$NNNNNN) 'N,'NNNNNNNNNNNNNNNNNNN 'N 'NNNNNNNNNNNNN" '#N'$NNNNNN) (N,(NNNNNNNNNNNNNNNNNNN (N (NNNNNNNNNNNNN" (#N($NNNNNN) )N,)NNNNNNNNNNNNNNNNNNN )N )NNNNNNNNNNNNN" )#N)$NNNNNN) *N,*NNNNNNNNNNNNNNNNNNN *N *NNNNNNNNNNNNN" *#N*$NNNNNN) +N,+NNNNNNNNNNNNNNNNNNN +N +NNNNNNNNNNNNN" +#N+$NNNNNN) ,N,,NNNNNNNNNNNNNNNNNNN ,N ,NNNNNNNNNNNNN" ,#N,$NNNNNN) -N,-NNNNNNNNNNNNNNNNNNN -N -NNNNNNNNNNNNN" -#N-$NNNNNN) .N,.NNNNNNNNNNNNNNNNNNN .N .NNNNNNNNNNNNN" .#N.$NNNNNN) /N,/NNNNNNNNNNNNNNNNNNN /N /NNNNNNNNNNNNN" /#N/$NNNNNN) 0N,0NNNNNNNNNNNNNNNNNNN 0N 0NNNNNNNNNNNNN" 0#N0$NNNNNN) 1N,1NNNNNNNNNNNNNNNNNNN 1N 1NNNNNNNNNNNNN" 1#N1$NNNNNN) 2N,2NNNNNNNNNNNNNNNNNNN 2N 2NNNNNNNNNNNNN" 2#N2$NNNNNN) 3NH3NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 3#N3$NNNNNN) 4NH4NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 4#N4$NNNNNN) 5NH5NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 5#N5$NNNNNN) 6NH6NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 6#N6$NNNNNN) 7NH7NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 7#N7$NNNNNN) 8NH8NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 8#N8$NNNNNN) 9NH9NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 9#N9$NNNNNN) :NH:NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" :#N:$NNNNNN) ;NH;NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" ;#N;$NNNNNN) <NH<NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" <#N<$NNNNNN) =NH=NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" =#N=$NNNNNN) >NH>NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" >#NG>$NNNNNN) ?NH?NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" ?#N?$NNNNNN)Dl~~~~~~~~~~~~@*,A*,B*,C*,D*,E*,F*,G*,H*,I*,J*,K*,L*,M*,N*,O*,P*,Q*,R*,S*,T*,U*,V*,W*,X*,Y*,Z*,[*,\*,]*,^*,_*, @NH@NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" @#N@$NNNNNN) ANHANNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" A#NA$NNNNNN) BNHBNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" B#NB$NNNNNN) CNHCNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" C#NC$NNNNNN) DNHDNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" D#ND$NNNNNN) ENHENNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" E#NE$NNNNNN) FNHFNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" F#NF$NNNNNN) GNHGNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" G#NG$NNNNNN) HNHHNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" H#NH$NNNNNN) INHINNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" I#NI$NNNNNN) JNHJNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" J#NJ$NNNNNN) KNHKNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" K#NK$NNNNNN) LNVLNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) MNVMNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NNVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ONVONNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) PNVPNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) QNVQNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) RNVRNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) SNVSNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) TNVTNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) UNVUNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) VNVVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) WNVWNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) XNVXNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) YNVYNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ZNVZNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) [NV[NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) \NV\NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ]NV]NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ^NV^NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) _NV_NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dl~~~~~~~~~~~~hhhhhhhhhhhhhhhhhhh`*,a*,b*,c*,d*,e*,f*,g*,h*,i*,j*,k*,l*,m*,n*,o*,p*,q*,r*,s*,t*,u*,v*,w*,x*,y*,z*,{*,|*,}*,~*,*, `NV`NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) aNVaNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) bNVbNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) cNVcNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) dNVdNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) eNVeNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) fNVfNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) gNVgNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) hNVhNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) iNViNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) jN VjNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) kN VkNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) lN VlNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) mN VmNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) nN VnNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) oNVoNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) pNVpNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) qNVqNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) rNVrNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) sNVsNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) tNVtNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) uNVuNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) vNVvNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) wNVwNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) xNVxNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) yNVyNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) zNVzNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) {NV{NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) |NV|NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) }NV}NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ~NV~NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N!VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N"VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N#VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N$VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N%VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N&VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N'VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N(VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N)VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N*VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N+VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N,VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N-VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N.VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N/VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N0VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N1VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N2VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N3VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N4VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N5VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N6VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N7VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N8VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N9VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N:VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N;VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N<VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N=VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N>VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, N?VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N@VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NAVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NBVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NCVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NDVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NEVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NFVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NGVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NHVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NIVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NJVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NKVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NLVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NMVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NNVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NOVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NPVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NQVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NRVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NSVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NTVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NUVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NWVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NXVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NYVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NZVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N[VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N\VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N]VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N^VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, N_VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N`VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NaVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NbVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NcVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NdVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NeVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NfVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NgVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NhVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NiVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NjVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NkVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NlVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NmVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NnVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NoVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NpVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NqVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NrVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NsVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NtVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NuVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NvVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NwVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NxVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NyVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NzVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N{VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N|VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N}VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N~VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)2$ hhhhhhhhhhhhhhhhhhhhhhPH@0(  >$@j52,,, Sheet3gg  S  dMbP?_*+%,&ffffff?'ffffff?(?)?M2WebEx Document LoaderTC odZZLetterGISUDINU"TJjSMTJ"dZZ333333?333333?&<3UPHP0(  >@ Sheet5ggD ?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. ns:ds="http://schemas.openxmlformats.org/officeDocument/2006/customXml">/f#xThisWorkbookSheet1- __SRP_4X,__SRP_5iKME (SLSS<N0{00020819-0000-0000-C000-000000000046}H(%H0(8V^xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2hp U&cT& 2חF V?H FQ OVL6x,CommandButton1, 1, 0, MSForms, CommandButton,CommandButton2, 2, 1, MSForms, CommandButton,CommandButton3, 3, 2, MSForms, CommandButtonQ OVL6& 2חF V?HMEPSLSSs6" <<N0{00020820-0000-0000-C000-000000000046}  @`  $`X|k (`  ,`  (% %*h4\0@ %*<h`@ %*Dt@8@8h %P%&x8(X\ V^*\R8004*#5d$*\Rffff*0<63935439$*\Rffff*0;639353f388h@HL"  " ( " 08@ " H XP* A"oh@A&oPA*o8QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassInvestor Details$.B@0o Attribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ControlCommandButton1, 0, MSForms,  #2, $;#3, $#PAC SubK*1_Click() Call _fill_WS1 EndA 2`Validc3APClearWorks_AcXtiv@0's@("Inveyr Details").Protect Password:="p", UserI nterf@Only:=F˛(CSMrU  1Y 89`1 @9`q H9!`LIYq0` Ey1?0   <   $ 0   0   4 < D 8@HLwrU X$)`$i`$`$ ` y@\4 @h< @tDn#Sheet2 o__SRP_68__SRP_7gSheet3<L=G)Z@ͣ[B} F6eY?oHXx6eY?oHXL=G)Z@ͣ[B}ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} ,` \h@% %2 %@@@`\xV^$*\Rffff*0=6393543a4" X ` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassError$.B@0oxp6Attribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+)Error#F(>EndM rU H11Y4IYq0` 0   4XrU @$`\n#<rJ穼)I& F, #VMEg=x, #VMEg=rJ穼)I&ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} ,` \h@% %4 %@@@`\xV^$*\Rffff*0>6393543a4" X ` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassSheet3$.B@0oxp2Attribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+o)$(?EndN __SRP_8 8__SRP_9gSheet4Sheet5rU X7174IYq0` 0   4XrU @$`\nS;#xME (SLSS<N0{00020820-0000-0000-C000-000000000046} ,h@%h@@xV^" X"` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassRead Me$.B@0?xoph8Attribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+)Read Me$( ?End N /V#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}H(%H0(8V^xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU $`$`$Module1%|__SRP_2jD__SRP_3_VBA_PROJECT)0*#14*\R0*#1*\R1*#65*\R1*#98*\R1*#42*\R1*#90*\R0*#2*\R0*#13*\R0*#9*\R0*#12   (08@HPX`hpx   "       ( 0 8 @ H P X ` h p x            "d!||xMEH@(<<> k ::i ls$i 8iErro@\ `ZT' PP  r8 X  ` ;;>i ei row i Err@ ror!`A@` InB@0x  `ailE  p` ck ``yi0$.iPtiialC@\ ell)`Tvest`LpHO p  `c%`oks(`.xls`PInve  `jk >>iInveii@\ MA`ZTMPp*Seells.RanX x P`  iiB@i@ pass `h`k /ihii@\  `B`kH Hih ii@\  x`xEPk _i iF@'Msi row@\ p 0`xH`k viWIfiunteir (c@\ n ``K`kp iiietai@\  `HN`k( iH ihi Det@\  X`0Q`k ii  i@\ Inve `X^4k i$ii @\ `ZTPX '@ @@  x `  ##iiiiIN@ Inve`Z$'stor Det X``n@k %%ii io @\ Stop `w`k i iiBlan@\ want `xqPkP IIipletiiiX @\ @ `xzPk i{(iH i@\  8 `x}Pk .iiimber@\ 1 or !`x`kx !Fip i%iStop@\   "``o0 "!!^iPipusbaii8i:  r<@>@B( @Hx@L @R, @V4 @\h@@`H@fT@j\@pXh@tx @8pXX 0@PP 8 Xh`8(8P x pHx0xXP"p#$" "#$"(#8"#<>@BDJLN@vl @"\ "PRTVXZ\FP"H^`bdjn|@xL @z< h".rp@"8 @4 @#$ @# @@# @X# @# @ @ @# @ @ "@ @0$ @| %%%%$%.@0%p @H%` @\ @`%L @x%< @%, @% @ @& @O 0&% @& @ %(()())))**(&(0'H'x'&'&`t'&^\@`'H @(8 @4 @'$ @' @' @' @' @* @ ( @8( @0* @` @b @dt @fd @hT @jD @l4 @n8$ @pP( @rP @th @vh( @x @z( @|( @~@) @X) @p) @)t @)d @H*T @`*D @x*4 @*$ @* @* @* @ + @+ @8+ @h+ @P+ @+ @+ @+t @+d @+T @+D @,4 @@,$ @(, @X, @, @p, @, @, @, @, @- @- @0-t @`-d @H-T @x-D @-4 @-$ @- @- @- @. @8. @ . @P. @. @h. @. @.t @.d @.T @/D @.4 @(/$ @ @@/ @X/ @p/ @/ @ 22X00p0011@0H1@0t @0d @0T @0D @4 @1$ @ @1 @ @X1 p101@1 1X1@1 @ 11@`021@ @1 @ X1833033H3232@l 32.p@`3d @x3T @P @3@ @ 40 @3 @ @4 @2 @ @84 @P4 @ 76576@57h7(66X5557 5@l 0555@0 @X6 pr.@5 55#@5 55#@6 65(@ 76(@@6 @ @p6 @6 @x7 @6 @ @H7 @ @ @t p5@`7d @7T @D @4 @P$ @ 0786Z5[: =@;X;X>>x@>=9999;8p>8@l 88.r  @09X @H9H @D @`94 @x9$ @9 @9 @9 @8: @p; @: @ : @P: @0< @h: @: @: @: @ @ 8B@ @| : "*02@$:l @&\ @;L @;< @;, @; @; @< @< @H< @x< @`< @< @< @< @<| @=l @<\ @ =L @P=< @8=, @h= @= @= @= @ @= @ @( @, @. (;>@FH^JNR@48| @6l (>VXZ\P< P@(? AhB Ax?@?@(?`?@?@l P?(?@.rF@?L @?< @8 @?( @? @PB @8@ @ @@ @ @ @@ @@ @ B@ @@ @Ax @Ah @0AX @HAH @`A8 @xA( @A @ @h@ @A @A @B @ B @ @J @ @ @8B @-XDpD`EHhDCDC0ChCHC@l XC0C.rR@CX @CH @D @C4 @C$ @HE @@D @0C @E @ @ @D @D @D @D @ @E @ @J(D @p @0E` `@G@XG`HHH pGhFFFFPF0F@l @FF.r@FX @FH @D @F4 @F$ @0H @(G @ @G @ @ @G @G @G @G @ @H @ @JG @p @H` @6P @JIXJHKpJhIIIIPI0I@l @II.rV@IX @IH @D @I4 @I$ @0K @(J @ @J @ @ @J @J @J @J @ @K @ @JJ @p @K` (ML@M0NpXMPLLhLL8LL@l (LL.rX@LX @LH @D @L4 @L$ @N @M @ @M @ @ @pM @M @M @M @ @M @ @JL @p @N` PhN(PQ(H@P8OOPON OO@l ON.rZ@hOX @OH @D @O4 @O$ @Q @O @ @P @ @ @XP @pP @P @P @ @P @ @JO @p @P` @R ST(S RR8RQRQ@l QQ.r\@PRX @hRH @D @R4 @R$ @S @R @ @S @Q @ @@S @XS @pS @S @ @S @ @JR @p @S` TUUhU`WxVV8UPUUTTT@l TT.Hr>@ U\ @UL @UH @U8 @<( @U @> @(V @@V @ @W @B @ @XV @pV @ @D @V| @Vx @Vt @Wp @l @0W\ @L @JV< @HW, YX@YXZZ0ZHZXXhXXPX0X@l @XX.Hr@@X\ @XL @YH @XY8 @<( @(Y @> @Y @Y @ @Z @B @LX @ @Y @Y @ @NXp @Z` @PxP @`ZL @xZH @ZD @Z@ @< @, @JpY @Z ^\ ](^ ][\\]][[[@l [[0].HB@(\h @@\X @h]T @X\D @p\4 @]$ @\ @ @@^ @B @L @\ @@] X]] @ @] @ @] @] @p @]l @d @` @0 P @\@ @0 ( `^P``b8``b`__0_h`^c_@l  _^`@_0 .r@x_, @( @_ @_ @a @` @ @` @ @ @ @` `h`@x a`@`h @`X @aH `@(a8 @@a( @Xa @pa @a @a @a @b @a @b @0b @ @Hbx @h @xbd @b` @b\ @bX @T @J_D @b4 H_Jd(X@gg00gdd(deccc@ l cc0e.rH@@dD @Xd4 @0 @pd @d @g @d @ @he @ @ @@e Xee@ g@e@ex @eh @eX @eH @e8 @e( @f @(f @@f @Xf @pf @f @f @f @f @f @gx @h @eX @HgT @`gP @xgL @gH @D @Jd4 @$ @g @eBiijihiihhh@l hh.rP@ iX @8iH @D @Pi4 @hi$ @j @i @ @pj @ @ @j @(j @@j @Xj @ @j @ @Ji @p @j` @klxm8nmkhlklkkk@ l kkl.r^@lL @ l< @8 @8l( @Pl @ n @l @( @0m @ @ @m ml @ Pnm @Hm @`mx @h @lX @mT @mP @mL @mH @D @Jl4 @$ @n m2@(pXp0qp@p`qppPoohoo8oo@l (oo.r`@oX @oH @D @o4 @o$ @Hq @p @ @q @ @ @ @p @p @p @p @ @ @q @p @ ` @P @o@ svHw0wsrxwPppvvhrrrr`w0r@l @rr."*@rX @rH @D @r4 @r$ @0t @(s @ @s @ @ @$ @@s @s @&Xs @st @td @tT @HtD @xt4 @`t$ @t @t @t @t @u @t @ u @Pu @8u @hu @ut @ud @uT @uD @u4 @u$ @(v @v @@v @ @Xv @ @( @, @.s @v @v @w @w @ @psp @` Prr02b@vP Xypy0xHzyxyx0xhxHx@l Xx0x. rd@xX @xH @D @x4 @x$ @`z @@y @ @y @ @ @0z @y @(y @y @z @z @ @ @Jyp @` `}@|HX|H}(p|h{{{{P{0{@l @{{.r@{X @{H @D @{4 @{$ @0} @(| @ @| @ @ @| @| @| @| @ @} @ @J| @p @}` @zhP @~X`Hph~~~~P~0~@l @~~.r@~X @~H @D @~4 @~$ @0 @( @ @ @ @ @ @ @ @ @ @ @ @J @p @` @xP @XHxphP0@l @.rj@X @H @D @ȁ4 @$ @0 @( @ @ @ @ @ @ @ @Ђ @ @ @ @J @p @` X`Ѕ0PP8@ l (.Hrl@h\ @ȄL @H @@8 @<( @ @>p @p @ @ @x @ @ @ @ @ @ @| @x @0t @Hp @l @\ @L @< @J(, @ y##aV^$*\Rffff*0;639353f3*\R1*#220*\R1*#337*\R1*#10d*\R1*#101*\R0*#f*\R 7 ;  4U04Uh  0F+2A8@ H&+X2A    ;      $+02AX$+rGHP 2AX B   V(7 0  <H&9C $X0J  ,((7X &:(7 &:"  8@ 0H(7x4F)    (  0  8 2A@ x B            ( 8 H X h x             ( .0 ` x     ^ L( 6R 8X   ,(( X  ` ,(p   ,(   ,(0 8,(Hx ,( ,( ,( P>[X,( )2R  ,(@  px ,(     ,(     %( HX ` "h p  V    Ib821P       B  .  (08 B @ HPX` h  Rp"X     (^p(p &P     (^x(( &P      (^0bX &P  ( 0  @ (^P(^x8(8@&PHp      (^(^8&P       fS x  &P     2$&#(P X&#h &#  &#   06;@x   J   8&#Hp x  6;E %0: @ H P p&# &# &#( 0&#@hp D;        "T @  0P  p 0!(H!$>h!!jS!" "("&P0"X" h"x"  ;"S"(#8#@#&PH#p# ##   #jS#$ $($&P0$X$ h$ x$  $jS$$%%&P%@% P% `% h%  dSp% %% % &P%  & 0&@&H& P& X& h'x' ' '' ' B ' 5'5'  N' ( F(8i0(  h( x( f^( (( ) &M) 0) @) P) X) h)x) ) )) ) B ) 5)5)  N) * "K*F8* 6iX*  *  %* 8i* 6 * 0+ ^8+ ++ + &M, (, 8,H, bP, ^, `-p- x- &M- - -- 2- .^ ....&M./ /0/ 8/ @/ P/`/ h/ x// //B/ ///// (m/(k0(m00(mX0(k0(m0(k0(k0(k 1(kH1(kp1(k1(k1(k1(k2(k82(k`2(k2(k2(k2(k3(k(3(kP3(kx3 @3 D3(5D\05 x6D67D79D\ 9 h:Dp:;D\; =D\= X>D\`> ?D\? @D\A HBD\PB CD\C DD\D 8FD\@F GD\G HD\H (JD\0J xKD\K LD\L ND\ N hOD\pO PD\P RD\R XS`S    hS " pS (xSSSSS SS S ,S4T  PT0`TT(TTT :T .(UXU"UV.(V.XV>V2V>W6@W.xW.W W"W  X(XD@X2X^X" Y HYXYhY $pY(Y Y(Y.Y.(Z(XZZZ Z(Z.Z([8[@[(P[0x[([[[ B [  N[ \ "K\"K8\F`\\ \\  \&\Hi\ ]040]`] h]>i] ]04]^^@i(^ h^04x^^^6i^ ^04_8_@_6iP_ _04___:i_ (`048`h`p`<i` `04` aa a@i@a a04aaa<ia b040b`bhb6ixb b04bbb4ic @c04Pccc8ic c04cd d8i8d pd04ddd@id e04(eXe`e@ie e04eff:i f `f04pfff:if g04g@gHg6iXg g04ggg<ig 0h04@hphxh>ih h04hii<i0i pi04iii8ii j04jHjPj:ihj j04jjj8ik @k04Pkkk8ik k04kl l6i0l hl04xlll<il m04mHmPm6i`m m04mmm:im 8n04Hnxnn6in n04noo:i(o ho04xooo:io p04pHpPp8ihp p04ppp<iq @q04Pqqq<iq q04q r(r:i@r r04rr rr rr s04s @sHs %Ps04ps sss  s ss  s st tB  t  t tt t &t t u " u (u.@u (pu u B uuuuu  NuFuv v (v"5@v rhvv$v .w  w 0w^Pwwww&Mw x 0x@x Hx Px^Xxxxy&My0y @yPyXy `y   hy py yy y yy y B  yyyyyyy  z z@z Pz `zhz pz"z  z n`{{ { 2{ | 0|8| @| zH| || | &| } } 0}8}@} H}nh}} }}&} ~ 0~@~ H~ X~h~ p~ ~~~ B ~~~~~~~  N~F~ ( 8@ HP X` hp x"5 (n  2N  @P$X "p    . ȁ؁ ^&M؂  z^  &M    n^@ Ȅ&MЄ  4 f^X Ѕ؅&M ( 0 @P X hxB   NFІ  "5( <NP$ .  Ї  |^ p x^ (&M0X hx  ^(0&M8` p      Ȋ ؊ B   "( P`p(0&8` p    Ќ ،B  N"T 8H^X&M H Xh p     B ȎЎ N؎"T 0^@؏&M  0@ H Xh p B  N"TА ^ȑБ&Mؑ  ( 8H P `pxB  N"T ؒ^&Mؓ    ( 8HPB X` Nh"T ^Дp&M ȕؕ    (0B 8@ NH"Th ^Xhp&Mx  ȗ ؗ  B  ( N0"TP x^8HP&MX   ș Й  B  ( 0  N8FXEx   Ț!ؚ "5 4N  X `h p x  + ,  &3؛ ( @ HP (X6Bx  (Ȝ$   ((&Hp x (@B  ( @ HP (X``x؞  (6BH PX (` FOȟ П؟ (\`` hp (x Ƞ (Р<B0 8@ (HV`h ȡС (ءf`` hp (x Ȣ (Т>B0 8@ (Hh ( (06BP      ȤФ ؤf^P `h&Mp   Х   B    (08  @`  f &(P ` p    Ч  B  N"T  HXhBx j^Ш@PX&M` j^(8@&MHp   Ȫ ت  B  NF( H%X.-x l^0@H&MPx   Ȭ Ь  B  NF0 P ` p"T,ȭ0ح(Ю$>j^( &M C^( Ȱ&Mа   j^(&M j^&MȲ ز d^`px&M  ȳг س    ( B 08 N@F` ^HX`&Mh   ȵص   B  N F@ `p^(8@&MHp     з B  NF  @P^` &M(P `p x   ȹ B й5ع5  N ( F08iP    $ ^ `p x &M  Ȼ л     0] ] ] ]  ] (] P] H] x] p] ] ] ] ] ] ] @] ] h] ] ] ] 8] ] `] ] 0] ] DXf9f] Dbd}'<'>'@'B'D'v'J'L'N'P'R'T'V'X'Z'\'F'H'^'`'b'd'x'z'j'nA|passError$.B@~'rError$.!B@*$'pB2Investor Details$.%!d$'G2Investor Details$.%!d$'  G2Investor Details$.%(Please enter CINA@passInvestor Details$B@0|d Please Prefill Company NameA@passInvestor Details$B@0|@k8k0A'rError$.!B@*$'p{$'$'v vStop r passInvestor Details$B@0Error! Please refer ErrorA@|@ re Invalid data present at row no:: p .Kindly refer Er      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdeghisklmnopqrbtuvwxyz{|}~rorSheet Error! Please refer ErrorA@|kpassInvestor Details$B@0oh]8PWorkbooks("InvestorDetailExcel.xls").Sheets("Investor Details").Unprotect "pass"passInvestor Details$.B@~MsgBox rowCount6ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).RowInvestor Details$.B@0A1$.%.O10:O p$ %' Investor Details$.%(%Workbooks("InvestorDetailExcel.xls").passInvestor Details$.B@0Investor Details$.B@0zPHpassInvestor Details$.B@0Investor Details$.B@0iXMACROS BY EXCELZOOM.COM]]*Set rangeSheet = Cells.Range("A15:O65536")passInvestor Details$.B@~X   A15:O65536$%.   !$ B@k..passInvestor Details$B@0o]++++++++ + + + + + +++++++++++]P]h ''MsgBox "RowCount Value ::::" & rowCount   p rStop'z`kX   WIf ((colCounter = 1) Or (colCounter = 4) Or (colCounter = 9) Or (colCounter = 10)) Then           $Investor Details$.%!d'  $Investor Details$%$' Investor Details  $$'k Investor Details  $$'kX Investor Details  $$'k Investor Details  $$'k Investor Details  $$'k Investor Details  $$'k8 Investor Details  $$'k Investor Details  $$'k      Investor Details  $$'   e Investor Details$%$' $INDIAInvestor Details  $$' 'dInvestor Details  $$' 'k@k8d0Investor Details  $$'k   Stop StopStop'ki]D*  %!'   $ : $8Blank Rows Found.Do you want to Clear Rows from row no.  to   ???'    Deletion Confirmation$'  GC@j|X qP |H k@ o(   : $%!''z  'i 8]]]]   $.%!d'   $%$'    $%$Error at line number . column 1 or 3 (Investor First or Last Name)  : Mandatory Field' rzx kp  rError$%( r 'rStop'k e e  $%$Error at line number 6 column 4 or 6 (Father/Husband's First or Last Name)  : Mandatory Field' rzH k@  rError$%( r 'rStop'k e  e  $%$Error at line number 8 column 10 or 11 either District or Pincode is mandatory' rz( k  rError$%( r 'rStop'k  e  e  $%$  $%$Error at line number  Column  D Either Folio Number or DP Id-Client Id-Account Number is mandatory' rzk  rError$%( r 'rStop'khk`  e  $%$  $%$Error at line number  Column  D Either Folio Number or DP Id-Client Id-Account Number is mandatory' rz`kX  rError$%( r 'rStop'kkdError at line number  column  ( ) : Mandatory Field' rzpkh  rError$%( r 'rStop'kd    Investor Details  $'k  Investor Details  $'kh  Investor Details  $ 'k( Investor Details  $ 'k For Country Investor Details  Sheet3A2$'k For FolioNoIf (colCounter = 12) ThenD IsValid = validFolioNO("Investor Details", rowCounter, colCounter)End IfFor DpIdClientIdAccountNo  Investor Details  $'k For State  Investor Details  Sheet3B2$'  $%' Stop Investor Details  Sheet3$'BkkFor Character Length Investor Details  $'kP Investor Details  $'k Investor Details  $'k Investor Details  $'k  Investor Details  Sheet3InvestmentLtgtn$ 'k For Proposed date  $"   $%$'$ $  $$$'& &JAN &FEB &MAR &APR &MAY &JUN &JUL &AUG &SEP &OCT &NOV &DEC $- *'( ( $- *', $ , $ , $'. .Error at line number  column  ( ) : Invalid Date Format' rzk  rError$%( r 'rStop'k $0 2$0 Error at line number  column  ( )3 : should be less than or equal to the system date.' rzk  rError$%( r 'rStop'khd`Error at line number  column  ( ) : Invalid Date Format' rzk  rError$%( r 'rStop'kdxError at line number  column  ( ) : Invalid Date Format' rzk  rError$%( r 'rStop'kdError at line number  column  ( ) : Invalid Date' rzk  rError$%( r 'rStop'kkk Stop >Stop BStop @Stop FStop HStop ^Stop JStop 4Stop NStop RStop 6Stop VStop XStop ZStop \Stop PStopStop'<k <StopStop'kXiP8 :$!'< :$!@'>  $.%!d'   $%'B BA1:A248Sheet3$% %F'D D$HError at line number  column  ( ) : Invalid Country'J rzk J rError$%( r 'rStop'k StopStop'>k >StopStop'kXiP :$!'< :$!@'>  $.%!d'   $%'B   $%'L LB2:B37Sheet3$% %F'N N$H LNA BINDIA BA1:A248Sheet3$% %F'P P$H&$stateName=NA and CountryName=invalidError at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'J rzk J rError$%( r 'rStop'kd Y(stateName = NA and CountryName = INDIA) OR stateName = invalid and CountryName = 'INDIA'Error at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'J rzk J rError$%( r 'rStop'k0d*stateName = valid and CountryName <> India B$INDIAError at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'J rz k J rError$%( r 'rStop'kk StopStop'@k @StopStop'kp Next CounteriP]8]P]h]] ^ ! \%%!'R ^ ! \%%!'` ^ ! \%%!'T ^ ! \%%!'V ^ ! \%%!'b ^ ! \%%!'X ^ ! \%%!'d ^ ! \%%!'f ^ ! \%%!'h ^ ! \%%!'j ^ ! \%%!'l ^ ! \%%!'n ^ ! \%%!'p ^ ! \%%!'r ^ ! \%%!'t ^ ! \%%!'v ^ ! \%%!'x ^ ! \%%!'z ^ ! \%%!'| ^ ! \%%!'~ ^ ! \%%!' ^ ! \%%!' ^ ! \%%!' ^ ! \%%!'9MsgBox "rowColumn11: rowColumn11 value is " & rowColumn11 R ` R T R V R b R X R d R f R h R j R l R n R p R r R t R v R x R z R | R ~ R  R  R  R  R' ` R ` T ` V ` b ` X ` d ` f ` h ` j ` l ` n ` p ` r ` t ` v ` x ` z ` | ` ~ `  `  `  ` e `' T R T ` T V T b T X T d T f T h T j T l T n T p T r T t T v T x T z T | T ~ T  T  T  T e T' V R V ` V T V b V X V d V f V h V j V l V n V p V r V t V v V x V z V | V ~ V  V  V  V e V' b R b ` b T b V b X b d b f b h b j b l b n b p b r b t b v b x b z b | b ~ b  b  b  b e b' X R X ` X T X V X b X d X f X h X j X l X n X p X r X t X v X x X z X | X ~ X  X  X  X e X' d R d ` d T d V d b d X d f d h d j d l d n d p d r d t d v d x d z d | d ~ d  d  d  d e d' f R f ` f T f V f b f X f d f h f j f l f n f p f r f t f v f x f z f | f ~ f  f  f  f e f' h R h ` h T h V h b h X h d h f h j h l h n h p h r h t h v h x h z h | h ~ h  h  h  h e h' j R j ` j T j V j b j X j d j f j h j l j n j p j r j t j v j x j z j | j ~ j  j  j  j e j' l R l ` l T l V l b l X l d l f l h l j l n l p l r l t l v l x l z l | l ~ l  l  l  l e l' n R n ` n T n V n b n X n d n f n h n j n l n p n r n t n v n x n z n | n ~ n  n  n  n e n' p R p ` p T p V p b p X p d p f p h p j p l p n p r p t p v p x p z p | p ~ p  p  p  p e p' r R r ` r T r V r b r X r d r f r h r j r l r n r p r t r v r x r z r | r ~ r  r  r  r e r' t R t ` t T t V t b t X t d t f t h t j t l t n t p t r t v t x t z t | t ~ t  t  t  t e t' v R v ` v T v V v b v X v d v f v h v j v l v n v p v r v t v x v z v | v ~ v  v  v  v e v' x R x ` x T x V x b x X x d x f x h x j x l x n x p x r x t x v x z x | x ~ x  x  x  x e x' z R z ` z T z V z b z X z d z f z h z j z l z n z p z r z t z v z x z | z ~ z  z  z  z e z' | R | ` | T | V | b | X | d | f | h | j | l | n | p | r | t | v | x | z | ~ |  |  |  | e |' ~ R ~ ` ~ T ~ V ~ b ~ X ~ d ~ f ~ h ~ j ~ l ~ n ~ p ~ r ~ t ~ v ~ x ~ z ~ | ~  ~  ~  ~ e ~'  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e '  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e '  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e '  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e 'k,i,passInvestor Details$.B@~]] ]0 ]H ]` ]x B2$!d'AP1Sheet3$.%!d$'B2Investor Details$.%!d$'  G2Investor Details$.%(Please enter CINA@passInvestor Details$.B@0| +k+1http://mca.gov.in/FOServicesWeb/NCAPrefillService'&' t'  '  '  '  '  CIN '   '  ZIE4 '  䴡'  '  '  ' ' post C@Host1http://mca.gov.in/FOServicesWeb/NCAPrefillServiceC@ Content-Typetext/xml; charset=utf-8C@ soapActionFhttp://mca.gov.in/FOServicesWeb/NCAPrefillService/getNCAPrefillDetailsC@Accept-encodingzipC@ C@5 B@q& //companyOrg1 %!d'//crDat %!d $' passInvestor Details$.B@~G2Investor Details$.%(B2Investor Details$.%(passInvestor Details$.B@0Invalid CIN/BCINA@kX% passInvestor Details$.B@~ G2Investor Details$.%(passInvestor Details$.B@0k$ passInvestor Details$.B@~ Z10Investor Details$.%(passInvestor Details$.B@0k($o $  $.%!d'#   $%'B   $%'L   $%' B$'B BINDIAKT LAndaman and Nicobar IslandsKT AndamanandNicobarIslandsSheet3$% %F' $HInvestor Details  Sheet3$'k"Andhra PradeshKT  AndhraPradeshSheet3$% %F' $HInvestor Details  Sheet3$'k!Arunachal PradeshKT ArunachalPradeshSheet3$% %F' $HInvestor Details  Sheet3$'kP!AssamKT AssamSheet3$% %F' $HInvestor Details  Sheet3$'k BiharKT BiharSheet3$% %F' $HInvestor Details  Sheet3$'k0 ChandigarhKT  ChandigarhSheet3$% %F' $HInvestor Details  Sheet3$'k ChhattisgarhKT  ChhattisgarhSheet3$% %F' $HInvestor Details  Sheet3$'Stop'kDadar Nagar HaveliKT DadarNagarHaveliSheet3$% %F' $HInvestor Details  Sheet3$'k8 Daman and DiuKT  DamanandDiuSheet3$% %F' $HInvestor Details  Sheet3$'kDelhiKT DelhiSheet3$% %F' $HInvestor Details  Sheet3$'kGoaKT GoaSheet3$% %F' $HInvestor Details  Sheet3$'kxGujaratKT GujaratSheet3$% %F' $HInvestor Details  Sheet3$'kHaryanaKT HaryanaSheet3$% %F' $HInvestor Details  Sheet3$'kHHimachal PradeshKT HimachalPradeshSheet3$% %F' $HInvestor Details  Sheet3$'kJammu and KashmirKT JammuandKashmirSheet3$% %F' $HInvestor Details  Sheet3$'k JharkhandKT  JharkhandSheet3$% %F' $HInvestor Details  Sheet3$'kX KarnatakaKT  KarnatakaSheet3$% %F' $HInvestor Details  Sheet3$'kKeralaKT KeralaSheet3$% %F' $HInvestor Details  Sheet3$'k( LakshadweepKT  LakshadweepSheet3$% %F' $HInvestor Details  Sheet3$'kMadhya PradeshKT  MadhyaPradeshSheet3$% %F' $HInvestor Details  Sheet3$'k MaharashtraKT  MaharashtraSheet3$% %F' $HInvestor Details  Sheet3$'kHManipurKT ManipurSheet3$% %F' $HInvestor Details  Sheet3$'k MeghalayaKT  MeghalayaSheet3$% %F' $HInvestor Details  Sheet3$'kMizoramKT MizoramSheet3$% %F' $HInvestor Details  Sheet3$'kxNagalandKT NagalandSheet3$% %F' $HInvestor Details  Sheet3$'kOrissaKT OrissaSheet3$% %F' $HInvestor Details  Sheet3$'kP PondicherryKT  PondicherrySheet3$% %F' $HInvestor Details  Sheet3$'kPunjabKT PunjabSheet3$% %F' $HInvestor Details  Sheet3$'k  RajasthanKT  RajasthanSheet3$% %F' $HInvestor Details  Sheet3$'kSikkimKT SikkimSheet3$% %F' $HInvestor Details  Sheet3$'k Tamil NaduKT  TamilNaduSheet3$% %F' $HInvestor Details  Sheet3$'kP TelanganaKT  TelanganaSheet3$% %F' $HInvestor Details  Sheet3$'kTripuraKT TripuraSheet3$% %F' $HInvestor Details  Sheet3$'k Uttar PradeshKT  UttarPradeshSheet3$% %F' $HInvestor Details  Sheet3$'kx UttarakhandKT  UttarakhandSheet3$% %F' $HInvestor Details  Sheet3$'k West BengalKT  WestBengalSheet3$% %F' $HInvestor Details  Sheet3$'k8 n0 n( BINDIA LNA NAInvestor Details  Sheet3$'k d LNA NAInvestor Details  Sheet3$'kX kP kH StopStop'Bk BStopStop'k i P Error at line number  column   (   $.%!d,) : Incorrect Country State District Mapping'J rz8 k0 J rError$%( r 'ri  passInvestor Details$.B@~E4Investor Details$.%(passInvestor Details$.B@0o` P ] ] 'Z]  $.%!d'   $%'  ' p     $ +. $@$ $[$  $`$ ${$ d $ $   $'  counter = counter + 1Error at line number  column  ( )1 : More than one consecutive space is not allowed'J rzk J rError$%( r 'rStop'ykdError at line number  column  ( )9 : Special Characters and Numeric Values are not allowed.'J rzk J rError$%( r 'rStop'ykk StopStop'Fkh FStopStop'k@i8x ] ]0 ]H '']`  $.%!d'   $%'  '  ] '     $ +  / F $@$ $[$  $`$ ${$  $/$ $:$  $@$ $[$  $`$ ${$   'k $/$ $:$   'kd'Error at line number  column  ( )& : Special Characters are not allowed.'J rz k J rError$%( r 'rStop'yk  Error at line number  column  ( ) : Should be alphanumeric.'J rzk J rError$%( r 'rStop'k StopStop'Nk NStopStop'khi` ]p]']']  $.%!d'   $%'  ' ]'](']@']X'     $ +/;R $@$ $[$  $`$ ${$  $-$ $/$ $:$  $@$ $[$  $`$ ${$   'k~ $/$ $:$   'k~ $-$   'kh~  '   $' -'counter = counter + 1Error at line number  column  ( )7 : More than one consecutive '-'(hyphen) is not allowed'J rzX}kP} J rError$%( r 'rStop'y}k|k|d|'Error at line number  column  ( )& : Special Characters are not allowed.'J rzH|k@| J rError$%( r 'rStop'y{k{{  Error at line number  column  ( ) : Should be alphanumeric.'J rz8{k0{ J rError$%( r 'rStop'kz    Error at line number  column  ( ) : Invalid Format.'J rz(zk z J rError$%( r 'rStop'ky StopStop'Hky HStopStop' kyixyp]]('Z]@  $.%!d'   $%'  '      $ + $/$ $:$ dhx $.$   $' Z 'Z .Error at line number  column  ( )( : More one decimal point is not allowed'Jkw Z Error at line number  column  ( )- : More than one decimal point is not allowed'J rzvkv J rError$%( r 'rStop'yvkxvdpvError at line number  column  ( )4 : Special Characters and Alphabets are not allowed.'J rzuku J rError$%( r 'rStop'yxukpukhu`u StopStop'^k8u ^StopStop' kuiu]8  $.%!d'   $%$' '  Error at line number  column  ( )N : Folio Number Should be alphanumeric and less than or equal to 20 Characters'J rzsks J rError$%( r 'rStop'kxs StopStop'NkPs NStopStop'k(si sP]  $.%!d'   $%$' ' < Error at line number  column  ( )O : DP Id-Client Id-Account Number Should be Less Than or equal to 60 Characters'J rzqkq J rError$%( r 'rStop'kq StopStop'Pkhq PStopStop'k@qi8q]  $.%!d'   $%$' ' # Error at line number  column  ( )D : Investor First Name Should be Less Than or equal to 35 Characters'J rzpkp J rError$%( r 'rStop'ko StopStop'Rko RStopStop'khoi`o]`  $.%!d'   $%$' ' # Error at line number  column  ( )E : Investor Middle Name Should be Less Than or equal to 35 Characters'J rz0nk(n J rError$%( r 'rStop'km StopStop'6km 6StopStop'kmimx]  $.%!d'   $%$' ' # Error at line number  column  ( )C : Investor Last Name Should be Less Than or equal to 35 Characters'J rzXlkPl J rError$%( r 'rStop'kl StopStop'Vkk VStopStop'kkik0]  $.%!d'   $%$' ' # Error at line number  column  ( )L : Father/Husband's First Name Should be Less Than or equal to 35 Characters'J rzxjkpj J rError$%( r 'rStop'k j StopStop'Xki XStopStop'kiii]  $.%!d'   $%$' ' # Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzhkh J rError$%( r 'rStop'k8h StopStop'Zkh ZStopStop'kgig]@  $.%!d'   $%$' ' # Error at line number  column  ( )K : Father/Husband's Last Name Should be Less Than or equal to 35 Characters'J rzfkf J rError$%( r 'rStop'kXf StopStop'\k0f \StopStop'kfifX]]'Z](]`'  $.%!d'   $%'  $%' ' 'd8e      $ + $/$ $:$ dd'ydkddkxd     '$'   $DELHI    e $HARYANAdc'kc   e $ CHANDIGARH $PUNJABdHc'k8c   e $HIMACHAL PRADESHdb'kb   e $JAMMU AND KASHMIRdb'kxb   e $ UTTAR PRADESH $ UTTARAKHANDdb'kb  # e $ RAJASTHANda'ka $ ( e $DADAR NAGAR HAVELI $GUJARAT $ DAMAN AND DIUd a'ka ( - e $GOA $ MAHARASHTRAd`'k` - 2 e $MADHYA PRADESH $$ CHHATTISGARHd0`'k ` 2 6 e $ANDHRA PRADESH $ TELANGANA $ PONDICHERRYd_'k_ 8 < e $ KARNATAKAd@_'k0_ < A e $ TAMIL NADU $ PONDICHERRYd^'k^ C F e $KERALA $ LAKSHADWEEP $ PONDICHERRYd8^'k(^ F K e $ WEST BENGAL $ANDAMAN AND NICOBAR ISLANDS $SIKKIMd]'k] K N e $ORISSAd@]'k0] N O e $ASSAM $ARUNACHAL PRADESHd\'k\ O P e $NAGALAND $MIZORAM $ MEGHALAYA $MANIPUR $TRIPURA $ARUNACHAL PRADESHd['k[ P V e $BIHAR $ JHARKHANDdp['k`[dX['kH[d@['k0[k([ Error at line number  column  ( ) : Invalid Pincode'J rzZkZ J rError$%( r 'rStop'k@Z StopStop'JkZ JStopStop'kYiY]8]P'Z]h  $.%!d'   $%' '  Error at line number  column  ( ) : Invalid Pincode'J rzXkX J rError$%( r 'rStop' insert here else partkhX StopStop'4k@X 4StopStop'kXiX]@  $.%!d'   $%$' '    4[A-Za-z][A-Za-z][A-Za-z][A-Za-z][A-Za-z]####[A-Za-z]' Error at line number  column  ( ) : Invalid PAN Format' rzVkV  rError$%( r 'rStop'kPVdHVError at line number  column  ( ) : Invalid PAN Length' rzUkU  rError$%( r 'rStop'khUk`U StopStop'`k8U `StopStop'kUiUX]  $.%!d'   $%' '   Investor Details  $ StopStop'd@TError at line number  column  ( ) : Invalid Aadhar Number'J rzSkS J rError$%( r 'rStop'k`SkXS StopStop'dk0S dStopStop'kSiS]  $.%!d'   $%' '  $"   $%$'$  YYYY/MM/DD$' $  $$$'& &JAN &FEB &MAR &APR &MAY &JUN &JUL &AUG &SEP &OCT &NOV &DEC $- *'( ( $- *', $ , $ , $'. .Error at line number  column  ( ) : Invalid Date Format' rzPPkHP  rError$%( r 'rStop'kO $0 2$0 Error at line number  column  ( )3 : should be less than or equal to the system date.' rz8Ok0O  rError$%( r 'rStop'kNdNError at line number  column  ( ) : Invalid Date Format' rzPNkHN  rError$%( r 'rStop'kMdMError at line number  column  ( ) : Invalid Date Format' rzhMk`M  rError$%( r 'rStop'kMdMError at line number  column  ( ) : Invalid Date' rzLkL  rError$%( r 'rStop'k0Lk(L StopStop'bkL bStopStop'kKiK]h  $.%!d'   $%' ' d Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzJkJ J rError$%( r 'rStop'kHJ StopStop'zk J zStopStop'kIiI]   $.%!d'   $%' ' d Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzHkH J rError$%( r 'rStop'khH StopStop'xk@H xStopStop'kHiH8]  $.%!d'   $%' ' d Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzFkF J rError$%( r 'rStop'kF StopStop'jk`F jStopStop'k8Fi0F :$!'< :$!@'>  $.%!d'E   $%' AS2:AS3Sheet3$% %F' $H`EError at line number  column  ( )l : Invalid Investment under any Litigation /Is the shares transfer from unpaid suspense account Column value'J rzDkD J rError$%( r 'rStop'k0D StopStop'lkD lStopStop' kCiCCAttribute VB_Name = "Module1" Public isValida teManor@y As Sng JCount@St~DisWct!InvType AlphapNume1@IndianP incod1Fo0rgieFolioEber4DpIdCl'@tIdAccNo}estorFirstؖtMiddlerLa]FatherHusb@`! " #AyriccqWPanX^@O@fBirth A adharqNomineXLengJointH`olderd Remarks(@yPLtgt9S0esFromUnpaidSuspe8nseDI FyrowxDoeFerrorZisPrefillZcked aBooleanA0Sub 3/()!$ J& $Allab +~|){ yJ,xv&cgsw(rn  Ftr DHq o*h9 q iJ d!U0 CaGove_Spaces Sheets("Ec").!mrote("`pass"`]jg= 1 Cells.Cer p= getRdr#f`CINTrim(K Detail.Range("B2`0TextaompanyRa= ? f?G8aIf f"" The>_u `8`MsgBox "Pse entF@WopPS4.PPw ord:=S, UserIfOnly:=TruM Exit AI Els# T  ` $O CS qc  or  End  D+FindABlank$)))t`')um1cul<*t\?CW:@,((*"Stop") A (: < 65537))&P8!!!R# >= #0,1 a pres!. at @? no::" &o!" .Kly H", vbdOK-, G or( !p(b5 Function ! Dim7ma/ RJ)'bookTe>LExcel.xBMU*4wWC4 On " GoToHler X(\'t!Y@ 'A)ve2 .\Sp ecial(xr1t1).7_ V[%ASeK4= 2p^A1f sumdiv8Appa .Sum(TaO10:O&)ao f  4, 5).[30rOPr % _^:x=Fa2]/U(`Qrr:)߿072 P'MACROS BY EXCELZOOM.COM113r"t3~x"8= 2x("A15:O65536") Sheets("Investor Details").Unprotect "pass" On ErrHGoTo RS|et rangeText0 = R .SpecialCells( _ x TypeConstants,EValuesFhEach` Inn If Trim( .=)"" @Then Clear9te9 End If N] RS:gNothin&g C= WorksPP@word:=, UserInterfaceOnly:=TrueKSub Function kidateAll( Dim ColNumber(23) As Doubl  01 1A2I2A3IQ@= 4I45UI5A6I6A7UI7A8I8A9I9A101C---1 .1B.1.1.1 /1B/1/1/1 01B010101 11B11111212121n2_ `121At= 21{col8Cou {ArowP@ ataRowAX'MsgBpox "@Jue :" & N`oh = D ~o(ere>= !@&co èXAtStop Exit _ %wA"= LRB#d(])Uk!*'( 3Or k Gn =n@V`  r ^/ R@,RS. SE,fieldĺú9,*)).!8 @N=\C Pu .9PisP/val©MiddleNameLength,cer5U%T@?FatherH@usband")$ o /1P XPan?i ?M= 1W?;IeOfBirЋsrLA@5Aadhar -<Nomine,OOO""1DJointHolder5r[RemaoooGoeM<> A& @10 OD17O 18O O9Lalpha eric c(Else' / :[crynmB¹O^WO^8Jb'UCaseP9"INDxIA"j1indianPincodeflagp $6; [foriegoAAo! IUSU_p2pMfaPyQ W0c8tcSa"r &R| 1 Pic F!FirstBlank CPLastW8ithLoO.= ,.Qq("*Sc0hDir@@:=xlPrevious).rB0Curr@ 15_a  INs 0 ! `s(BCow & ":"PLastRowWithValu e) msg = "Blank s Found.Do you want to Clear>from rno. Cur>rrT ???"respMsgBox(, vbQuestion + OKCancel, "DeleConfirmaE "If +vbOK Then .atentsCExit Sub End g IfNext  - Publi@c FuncdIs() As Boon%On Error GoTo  xs.SpecialCells(xType@Astvs, 23).C=|tB$Fa8lseBH. D : Tru@ = G  validateManory(She@etData>String,%$erADoNe,0 colN Dim errCCflagieldTi[C 'ʉ aRe sume x H f= 1sG3V]9-).= Trim(WorksABۄ=B>B!"^"^e}@(('=x 1)d?ow&3)))@D a1Xat line num>b:!bumn 1 ]3 (Inv`Fir st! Name) " : I F1o``ord >= 65537 !a]B~H8"B"e@,/.5`Vh aY=8+ 1\@-StopL AqE{>C3C4J9[ 6Ja|Jnt-@L&DdJ4G6 (Father/Husb'KKK<K K!K@(;%%@#%%6'M"O%(10_% !+JDd%79S11o%u r0o%Jrk%10q%11 e@(DislcJPincode is mnI JIB I$-$Ier$g7 I$ $$$ߠL[2?$/$tow(*$2/$6 /)esspo)o)h)Coltu4qP E*Fol0io N3xuDP Id-ClipAcc+l +u,+ ++++(+vP+3 P .-_*,ow_%_%pZ*_%5ݰ(SS&1_/_*fr_*z_*@U_*-_*/V _*_*_* o_*_*_*_*_*_*CTR*= "Stop" End = 65537 Then WExit Functio  Workshe ets("s").Cells( <, 1).Value > #a+ 1 fla + n@E(X= 1 OTr J3N4N6)Qis8id@,alphaNumeric("Invesh Det@ails",H~,)( Z+2LvalieFoliop  ͪ J3=1q DD@A5W"/nq/` b'F}iry83$$olBer, l3G"A2"3sE "@No$'o(LI' >X#O?&%@I@"DpIdClientIdAccO pVStat9?d/t@B@ disttNamSFData%=05~<> A* A"\DD3@&E~10g,.3',$CharacvLengthϓ&- = % \Firs o^< i .{9LafvDn;G4_nUFatherHusbpI( @$  w //yƘoai2/2~q%YesorNzz@c mTLtgtna91q43Proposed qdM1 IsPGe&("uem$cc%Trim(JJ1p"+P8(cc2)11} ffMid(UCase, 4, ~3ha{`R"0JAN"FE"BMARAPMAYJUYHJULyUGSDEPOCTNOVDEC"Ͻ gQInStr(1.c0$- Jvb1Compareqhhpcз izi4c-8 hh!ii) @f/4a0ݣ ///r/W&5Q , matl% "֕z/n< 3s/;po/g-% = OOr @(DD>"sNow)b?n errMsg = "Error at line number " & rowCount& colum.n22(XfieldTextp")"" : should be less than lequal toe system date."If ort>= 65537 TheExit F@unctioE nd If:Worksheets(").Cells( F, 1).Value ' h+ 1flaStop_&KEls~eC/&;҄Invalid D| FormatP6|{Jy׮xwב+lprAu zz_8A"_8'_8u_8?u_8e_8 n% ';! ??A8I>u<<^;;`;9 : ' ! OrH is@idryA"HDistrictqSta`AlphaN`umeicL(1L@mIndianPincodal"xZiegG Folioq; 2#estorFirstNam JMiddleg_La%FatherHusband?"CDpIdClientIdAccNoG!pMp aW!$$$RurO)-g 3%d*(Sяpza As S)ng,iPDouble,adRXL-7 ;)QQ!RowRange(Ie).P Col.P!G= s' 9 ).!qW On" Res`5 NYry)hI edzen!Chk Applica1.Match(X, OR3`"A1:A248"), 00KC#IsR @5)oGoTo 0@`Io?lu!@f°=bry;fp [:/f04I` df/Uerw Kf@4CP&#]C`{B/F.F"mFFFDU1AFst7FFFta1=F;?FtAFF OETOEq - 8 sA:,SheetData).Cells(rowCounter, colX) stateNameChk = Application.Match(@, Workss("3").Range("B2:B37"), 0If Is`ErrorAb) Thenx $^|"NA" Andry <> "INDI:8 cry%`A1:A248?a05i:i 'd=NA abb=invaliFd&/On @GoTo 0 sDtr= "at line number " ,& "um.n GyA( fieldTextA)A" : Incorrect + SA Mapping. Please selA an opA from the drop-down" 0Ke,>= 65537DWExit` FuncAKETIfɣH , 1).VaxlueDU)=" + 1 flag"StopH<' ElN'@OB) OR^ DM ' '&_F_F_F_F _F _FF!M_F_F %[_FNFY CE?B?IndiRaUC@t(()=Ӧ Ky& "flIbCK/BBb)??$az`lisid#f' TPKb&P 'Nc/ wZ getR() As DoubDle*Dimjl j1314600* R-`fve2$9p s. b(xlUpow 2WAowH2).Co3w3445566m77889f910101 f""1o&a:*&.&&&&&&&&''/'?'O'_'2_'2_'_'_'_'_'_'_'_'_'iMsgBox ""11:f1 mis'T1p@rv(B!' 0l@y\4m567Jmn8) And (rowColumn1 >= h9x10>1>2345Z6712U22224)) Then getR!unt 1 ElseIf (lj2ʉ)!NqqppNppF1Wp\N1N1N1'1'1'``'`'`a2`3`<88n8N8.8``8<#18\'`'`'``'`G'0`mn30mn40n^ 0>000{00 ///n40mn5~n ^ N>.0{0 0 0?00n50mn6~n ^ N>.0{Oolumn16) And (rowC6 >= h17|8>9>T201234)) Then getBRunt 6 ElseIf (7 3 S R 4.5 .Npp1pWp\F1F1F1G'O1O2O2O2O2`7`8`<n<`.<8`8<#`|#`#/`'``'```8`9``<`N<000{00`0/ln90У0 1 1  / ? O _ o   /1Oa ?, o1o1n101p11191  ?/d 1/ ? O _ o   1$FGwColumn11 >= ro23) And ( 4)) T@hen getRvunt 11 ElseIf (2 v1j 2 ?4U?5678e9101U1H1I1]I1UI1I1J2J2_ݚ 23*}|O>/>>==b = ](b,$b,$b,%b+b %b,b3b4bobbO>b>b=b b / ? O _ o   11    1n141051*  1/11  / ? O _ o   1b , 11n151p161z1  /111 1 / ? O _ o   11 , w1?66?1017?121<wColumn17 >= ro2) And ( |3|4>5>6789101111111J2J2J2J2J24)) Then getBRunt 17 ElseIf (ȴ8ʼ*))sOsszO=pb =(1](pbL (pb,(1(pbK pb ^M%pbL b8rb9|bob9ob9o9obobpb O= ](pb,(pb,o   ?11   & ?1}b9?1mn20?1~ n >1>1?1  /,? O _ o     g,?1<120?1011?1:1o ?12 ?1 / ? O _ o    d?1 ,?1=11?1012?1:1o ˴ (rowColumn22 >= p7) And8|9>10@1 2 3 4 Z5611U222J24)) Then@ getRunt 22 ElseIf (Ȕ3ʔ!t)sOssrrOr ]P1P1P1(1(1(1(pb =)pb+pb =)b23rb4|b9999o9ob/9pb ob ](pb,(pb,(pb,)+pb  m 3b|b401pIpf 1E@FunctioPf`Sub Prefill_WS1() Sheets("Investor Details").Unprotect "pass" Dim xmlhtp As New M@SXML2.@H TTP30zDo"cuDOMumentIsURL!String0sEnv}trCINm sompanyNatme 1= Range("B2TextS@Verspy`Trim(r3 AP10j?.2`F ""1uG Value " MsgBox "Please er 7(6!P!A Exit &'(("= "http://mca.gov.in/FOServicesWeb/NC~A*TE !`<?( v=""1.0 encod$utf-80""?>$= b& ""! $q LLKnk@8 79*Z10@8"9;SubAt Funct@ va? @jDiict(`ga As Strt, rowCounterDouble, colL ofielda{ `s ).Cells(9 '@On Err@qRhesu@NcrōWorks?x  G - 2Dst" a# 1 dD+ (kUCase(hc 4`6!#a]"NDIA"aGDAndaman a@Nicobar Isl@l!Applica!Q.Match( , .""8~3dĨ dF, Ž|IsHg is@= eO0Id̀! -hra Pradesh 7E+Q+O5Ot.OsOmvOF oAO%runachal_sU__*Qcr_tY*5;sN E1>0)lssam/(3.>s' xd'Bihar3t :wCh]igarNDoooo`&@Ns?Xhattis7E:: flag`"StoYodDad Na` Haveli>B2%C>>  isValid = error("Investor Details", rowCounter, 10, "Sheet3")  End If6Case ("Daman a$DiuCdistrictNameApplication.Match( , WoHrkss(.Rangeonm, 0ZIf I sE-) Thent~elh~iL̈L  \GoaKۙBKKGujarat?&?se<&% & rG'L 1|LHaryanLm&& &&&&&"dHimachal PradeshNN'D&(((( JammuBKashmir(ouou0eu2`uE ur}u[XO<(Jharkh@ s9Hooo) `ODsXKarnatakP4ocѦsXeralooooet"K???y????8? 4Laоadweep::'sXMadhya/w?w bbN /////&[vtr;T(;;ز isValid = error("Investor Details", rowCounter, 10, "Sheet3")  End If6Case ("Manipur=districtNameApplication.Match( , Workss(.Rang"ei, 0If0 IsE|+) pThenoyeghalayaᛟNLN  ݛizoramMܛEMM|NagMnd&te&G & t'ML1M`Orisstm& &&J&&&"$PondichyMM' '?''' Punjab''R~t? tb|t????X_:'Rajastha~nosIF___)e 0BsXSikkitoϛ֝_a1e??C?s????X?4Tamil Na|du&etO"&sOXelanu4TO'O'y8rQq___y____8_TUttar Pradesh:;;z Iror("Investor Details", rowCounter, 10, "Sheet3") End If6Case ("Uttar@akhanddistrictName = Application.Match( , Works s(.RanDge m, 0If IsEr-) Thens|isValidQeߞW BengalA?Og̊?O  SelectqCI(cryB<> "INDIA"̀A state N A&  CA8E8lse9K1= "&A@wk`߇?sȈflago"Stop"u$*Dĉ ; v A B Func  % "Dat@a As Sng鮡Double, ColumnL@e>bV=B at line number " &h" c k!&@(s().Cells(9).Text ) : @Incorrq Yry`( (Mapping"@=B%$ >= 6p5537L2eExit G.JK;#" @).^u!$*+=<+ 1 -C!Sub Cle8ar(8,).@Unprot)"ppass&Ev4`"aP,3 P ,alphaNume{'!)--@&/s.pDim i a'Y* %= 03arrAl#field. bL*C* (!iMh Ly,thF() - Re! +rF`i0 To UBhd(Ku 6i)PMid, i %) 3((> Chr(64,) a^<910)) _1Orb (96123)+g ١32u8nBU247"`I?'#8q_R_R]R (S" (pS)"`P@More tP oXconsecutive space is not allowed!: 8`FQ Q9 qyQQϲQQorQ}) 3^or @71xA Special07pcPs S G ! . @e Q :/qoq   1/|  BE  jNF1lzlisAmicI9=sO0  gFoli>ow?5*wԴ Dim i acounter As Doublelnlfx= 0ZR"arrAlNum()J fieldName = S@heets(Data).Cells(9, colC).TexBt J"Lengt6h?(G)) - 1Re c fspecialCharFlagIger"For iE0 To UByd(5Di)Mid\, + 1, 1.If (()(> Chr(64) And = 65537%Exit FunctioLL15"ar.s#%J= 5f= "Stopo3NFfT0(F0)$d` <@;<hp%5 pP;.\x; An|ZCo0+ 2d04@ 7"-"?O@ Q'%=0 q߂??߂?6More t` o '-'(0) is nWl /5 O|er1O /orO״flag = "Stop"  Exit For dEnd IfCL Else2specialCh(arF18trName~Error at line number " & ro@wCount&column (,fieldR+)" : S acIs ardot allowed.a|If eF->= 65537 pThen]u`nctio Worksheets("s").C ells( 4, 1).Valu.s7 I=P+ PNextGC?(ac\=P 0 A{n)LB*qlYqhou ld bemphaericnnnPniGg(hypB <> 2 Or firstLastHypa1)mconsecutives=0:?s?s.sIn validmat9p$sVip9rpe98C=ljisAl\Numeic1AkB4 a @g 6F% a(S!Data As String,Double , () Dpim iŊ  (carrAl%(@ G= -Bs'Ū9I).T"嫈A' Length1( ) - Re! i0 To UBd('Di)Mid ,  S@G@+( > r(\47~ <"58))) _@bث i=6]Aa5n@;o b 2d 4jQg"."L+  qgoJp"gMoopdmal point is no6ϓ ; (>t0v OO?y ʊ  *O]%< ) * ]'z* [9U_?____Zo a0thbO_ϳe t termɅoV~JAr] Wz= 65537 Then Exit Functio1DEnd\Worksheets("E").C ells( , 1).Value = strNa,me? = + B1$flag8"Stop" O isqidFolioNumb= ! bG#*val)O_I'O DpIdClien@tIdAccNo(SData As String, row Double, col )_ Dim ifieldP.s1g9 ).TextkTrim(?y*)$Length@!(B%Do(D> 6<0)Y@ at line nCr" &IH& "сFumn&II@.( D@)A" : DP Id-CdAd ċShould be Less'an or equal to, Characs@E6 فڂa?n`loIg FAqak_al__I-_6 2bZl_6_6t %lqT)>_6_6 >+lߧq4ߧB\l_6?6?6?63 $Z,?6?6?6"?6E?6?6?6?6?6 ?6#325+6PO"555q55FatherHusbandߢ?6?6?6lߢ(9, colCounter).Text fieldValue = Trim(Worksheets(SData).Cells0(row~ ) Length (2If (:> 35) Then strNamu"Error at line number " & n "umn(,tR& ")" : Father/Husband's First Should be LessKan Dequal toV Characs" feW >= 6p5537jExit Functio|End If(" 4, 1).ӄ G= + 1!flagg"Stop@2@@4JH2is@idPPOO=  3validateWE Middle/ As String,I@Double C@Dim iDEBooAko"voc0ppp ppp p ppXz?pp]pGp{pLast?pgm?p?pW?? #???e?Gp7ppkppq87*pperpmef`por7pp _lnd,7P"7o%w o 7indianPincodennnznnc4NFre= 0aarrAlNum(2"zFcTru= uuୱ&߭ѱF st9 kB 3#%<> 6%1FalsEARezcFi0 To UBd(U) -υ1i)@@a , in: E+q F(>r(`47) A9<58)) ?"qGor{ Q3QN30 w;Qq!> 110Bax< 89q h=ft( / ), 2o( =BU`Case(,,"DELHI" P$ 2_ 14u (0HARYANA _ӽC(0q=2/ 14/ 1 *sq9!/ % CHANDIGARH" Or PUNJAB5O/O/H,eElSseIf (fieldValue >= 17 And < 18) Then  ~UCase@(statej) = "HIMACHAL PRA DESH"El se\kvali dFlagOFa&EIf >P820mJAMMU AND K@ASHMIR}n2 0n93nUTTARFm Or y xAKHB@w3 @35@RAJA\ST@5?5<56u44DADuNAG@HAVELI";GUJARATADAMANbaDLIU%l | k@4@4@GDOA\MAH$SHTRAu5E5E M ADHYATrim(BCHHATTIS M߾"-?B ?BF50B54g߂QڠHRK!WTELANGANHPONDICHERRYHHHaS5F 6O$Do#2 KARNATAK1 1 /A1@!A 06y 6/AT O I TAMIL NADUAuO4_036? 7O?"KERAL-6LAKSHADWEEP__/er__"/_"ߡb'_"7_" 7_"_"Y"WEST BE?L EAsNICOByI2SpCDSSIKKIMC __%%%%%7_g 7´_YORISSBu      7_ 7״  A M RUNo_98BB",?:MIZORAkEMEGAYG|ANIPUR?:TRAA)7O7778oJ 86ߌ))"BIHAR" Or UCase(statefieldValue@) = "JKHAND") T@hen Else*Hval@idFlagFaLEnd If >PL HD@ If strNameError at line number " & ro@wCount&column { ())" : InD Pincode6"Qe<#>=@ 65537Exit Func8tioIDAG%$= + 1 f"StopD5# 8 6isIndianGb7 M,V  foriegE&(SUData As Strin g,@Doub0le, F) Dim iMcD = 0arrAl0Num(G= -#sg<9).Text =?(D&]!Length3( @<( > 12mmpmlmXlLami[llulk' insert here e par`<@dUnisFZmld GGa l P@eicF`Pan_ms \mmUd_fRfTrim(f#>g)cbf@ f<> 0e7%8= 1)SIsPAN8 Like "[A-Za-z]{#5XiKf (rI=-MsahOu>Ouv>Lx"Ou  -mat 7@@3OCW JC8 zE. ) _0__r0S5 |ergc z is@idZ&W  "^ 1bbAadhar ococќSZocf?c `b A?cזperic("estDetails"vx #@OOuO>OD ?Z0\6/o=M:::379|orݖX-$%4 > :i3T5!arNumber = "Stop" EndH IfH If isVali dAadh THhenZ vJa 0) \Is  cc0Trim(0R/"GC*2Format!, "Y/MM/DD"6(cc)L11K6KffMid(UCase , 4, 3B "JAN" Or CFEBHMARHAPIHMAYJUIJ$UL UGHSE"PHOCTHNOVHDEC"j>$gg=In(1@c@T-", vbComparve@hA@+ ii.c T6- hh;ii) W4;AEerrMs"Error at line n" &i{& "zhumn&{ (ObT%")!" : InB g~ Wb`@or>= 655 37<8 ExitƘ!/ F謵w$", 1).+[>?fla6ƓEUF2>5Now)I @IFIIshould be less than `Wequal toe system d .MJ/M)M1&&er&g"v=5&&  k Elsep %Jć%DJJ"JuII="kO"O"O"""K!n #oi7ooiiB" // xN'oooo//* =0///<<<Z^ jOZ [=3 P .*taTЊFsXUoeq??Nome???oS0? ??r?h Ba 1dounter, colC) Length = @(field ValuedIf (t> 100) Then strNamed"Error at line number " `& row"qumn2|(,uR& ")" : Father/Husband's Middle (Sho@uld bes"san equal to 35 Characs" eWL>= 658537kExit Funct io|End If(Works@heets(").Cells( 4, 1).' G= + B1flagStopd?h dis8idNome= " 1 HvalidateGM PublicR Joint HoldeB(SRData As String,Ӊ@Doeɰ CDim i G= sh9 .TextjwF&E Thi`+Vi iiiii~c,Vrwjuj kCtRemajs jjÞjjԀԠH LԁQj?jj?5~ ?jort?j?j?jB! 45*4P0l?4e93imYesorNo3h3h,gListAmn;kRow@@Range(E).PPe0Col.P OoPnk:@o On ResuNpe&sinvLtgtn0O?@ABCDEFGHIJKLMNOPQRSTV0   @PKR(4 %l@DFH%X$ X dD A`1`)XD6Xl@l@DFH%X$ X dD  `1\)XD6 l\0 ^l@($%DFH%X$ X dD  :]3)XD6(>#*#?*#@*1h2pgPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd  ^l@($%DFH%X$ X dD  :]3)XD6(>#*#A*#@*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd    ^l@($ %DFH%X$ X dD  :]3)XD6>#*#B*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd  *  ^l@($ %DFH%X$ X dD  :]3)XD6^l@($ %DFH%X$ X dD  :]3)XD68>#*#C*##*#D*1h2 pAPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdrU~| ##91Qq )IaYY !)9 I!I9YI!qyQq q A!!"# $1%i%%)%%y9 1%)*9&Y&y&&&&&'9'Y'y''' (**y(Y)- ,,I. 011Q2 4Q566A7633 8Y99aQ:::A;;;q//i+ <a<<<=1=a===9>>>?Q?? @Y@@@AIAyAAA!BQBBBB1CiCC?+# D)MIDqDDDEiEE FIFFFGYGyGG HQHHHIQIIIJAJJJ!KIKKK' L9LiLLLMN9O PiPQQR TTUAVVVYWW XH T T T T T :\l T T T$ T( T, T0 T4 T8 T< T@ T T TD TH TL TP :\L :\< T\ Td 7:$%4:\%8$ 8 d4)84 p;4:\%8$ 8 d4W )845 hU:$ %4:\ %8$ 8 d4= )846U:$%4:\ %8$ 8 d4= )846:\]3 F:%:$%4:\ %8$ 8 d4C)845+''':\N 6A:$%c%4:\ %8$ 8 d4)84:\]3+''':\N 6A:$%c%4:\ %8$ 8 d4)84  p;4:\%8$ 8 d4W )845 h  l+l:\]/p$'5$A:$%c%4:\ %8$ 8 d4)84+''':\N 6pG'':\Nh#*#| *F 2|6A:$%c%4:\ %8$ 8 d4)84H<$<Ll,|84LK7:@%P:T %d$ d dP)dP9c@%P:T %d$ d dP)dPC:@-%P(T%d$ d dP "h)dP5 Xd'T%.h#*F %$ Qdo %P$ P//P6 J(@%(%P:T %d$ d dP C)dP5 7:@%P:T %d$ d dP)dP:f@%P:T %d$ d dP)dP7:@%P:T %d$ d dP)dP:f@%P:T %d$ d dP)dPL0lh$dP  47:L%\:` %p$ p d\)p\KF<%%p'L%:`!%$ p"tp5ltx")xa :`]36 xq x" c="t c="xA:L%c,%\:` %p$ p d\)p\40xt p\XTTTTTTTT T T T T T  :^l@($ %DFH%X$ X dD  :]3)XD65^l@($ %DFH%X$ X dD  :]3)XD638>#*#C*##*#D*1h2 pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdKS>#*#E*##*#F*#l`*#G*#@*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd $ȃŃŃc#ll C 8/  #ll C H/  #ll C I/ #ll C J/ ? ;KCLCll C M2  p #ll C N/  _ ; CLCll C O2El@($ %DFH%X$ X dD )XD%:H]<:4]<'] :LC |l C P` 25  #ll C Q/  #ll C R/  #ll C S/ # #ll C T/ȃt ;UCLCll C V2  \MH@ W1Tl@l@DFH%X$ X dD  l)XD5l(H ]3V0l 9( X\6\:HY]/\:4Z]/\:$[]/L<\:\]/,\:]]/ \:^]/\:_]/\:`]/|\:la]/\L\:("< X<6L(H]@eS>#*#E*##*#F*#l`*#G*#f*1h2p PlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd;l\ g h gt/6vS>#*#E*##*#F*#l`*#G*#i*1h2p PlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdQS>#*#E*##*#F*#l`*#G*#f*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd,S>#*#E*##*#F*#l`*#G*#f*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdS>#*#E*##*#F*#l`*#G*#j*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdld00Ŕ 0Ŕ0Ŕ0Ŕ0ŔD0Ŕ04|:H]/$0$,0Ll:]/<,4080 <0@0l(0<64$l<* T0F :HlP\Dl\hl`\ld|!XDL<, |\L, 5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KFl@l@F\%H$ H d8 )Hi @:Lt%:\L%H$ H d8%(%$ u)H58  v_K^>#*#*##*#*8:G:wﳢ<2 |xtpl68\pM<p@(%:\%H$ H d8 C)H58p뫜p :\,,:\]3{ T0 :\lPD,l(,<< |xtplH8\Lt5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KKl@k%F\%H$ H d8 )HFl@l@F\%H$ H d8 )Hi @:Lx%:\L%H$ H d8%(%$ up)H58 p v0%:\y]/8:L:]<'`Ji @:Lt%:\L%H$ H d8%(%$ uP)H58 P vEK^>#*#*##*#<F*F8:\G`:Lz,2 LHD@<68`pMp@(%:\%H$ H d8 C)H58p뫜p :\ +^>#*#*##*#<F*F8:\G`:Lz,2 LHD@<68`pMp@(%:\%H$ H d8 C)H58p뫜p :\ 18 98:\:]@58/^>#*#*##*#<F*F8:\G`:Lz,2 LHD@<68`pMp@(%:\%H$ H d8 C)H58p뫜p :\  :\]3M T0i :\lptL4 l( pP< LHD@<H8`,f.,m%H$ Ha8v"i$%(%4$ @4 >#A$Btl)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468m%H$ Ha8v"i$%(%4$ @4 >#A$Btd)H468m%H$ Ha8v"i$%(%4$ @4 >#A$Bt\)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468m%H$ Ha8v"i$%(%4$ @4 >#A$BtT)H468k%H$ Ha8v"i$%(%4$ @4 >#A$t)H468k%H$ Ha8v"i$%(%4$ @4 >#A$d)H468k%H$ Ha8v"i$%( %4$ @4 >#A$T)H468k%H$ Ha8v"i$%( %4$ @4 >#A$D)H468k%H$ Ha8v"i$%( %4$ @4 >#A$4)H468k%H$ Ha8v"i$%( %4$ @4 >#A$$)H468k%H$ Ha8v"i$%( %4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$t)H468k%H$ Ha8v"i$%(%4$ @4 >#A$d)H468olk$]V8olod'olo\'olk]V'ToloT'Dolk]tV4'$olk]dV'olk]TV'olk]DV'olk]4Vt'dolkT]$VD'4olk$]V'olk]V'olk]V'olk]V'tolkd]VT'Dolk4]V$'olk]V'olk]V'olk]V'olkt]Vd'TolkD]tV4'$olk]dV'6 oltt,olk$]V8odk]V'o\k]V'TVD'4oTk]V$'tV'dV'TV'tDVd'D4V4'$V'V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'7 Btt,odolodk$]V8'odo\'odk]V'TodoT'Dodk]tV4'$odk]dV'odk]TV'odk]DV'odk]4Vt'dodkT]$VD'4odk$]V'odk]V'odk]V'odk]V'todkd]VT'Dodk4]V$'odk]V'odk]V'odk]V'odkt]Vd'TodkD]tV4'$odk]dV'6odtt,o\olo\k$]V8'o\od'o\k]V'To\oT'Do\k]tV4'$o\k]dV'o\k]TV'o\k]DV'o\k]4Vt'do\kT]$VD'4o\k$]V'o\k]V'o\k]V'o\k]V'to\kd]VT'Do\k4]V$'o\k]V'o\k]V'o\k]V'o\kt]Vd'To\kD]tV4'$o\k]dV'6o\tt,olk$]V8V'odk]V'To\k]VD'4oTk]V$'tV'dV'TV'tDVd'D4V4'$V'V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV' Btt,oToloTk$]V8'oTod'oTo\'oTk]VT'DoTk]tV4'$oTk]dV'oTk]TV'oTk]DV'oTk]4Vt'doTkT]$VD'4oTk$]V'oTk]V'oTk]V'oTk]V'toTkd]VT'DoTk4]V$'oTk]V'oTk]V'oTk]V'oTkt]Vd'ToTkD]tV4'$oTk]dV'6oTtt,tolk$]V8tV'todk]V'Tto\k]VD'4tV$'toTk]V'tdV'tTV'ttDVd'Dt4V4't$V'tV'tV'tVt'TtVD'$tV'tV'tV'tV'dtVT'4tV$'ttV'tdV'A tBtt,dolk$]V8dV'dodk]V'Tdo\k]VD'4dV$'doTk]V'dtV'dTV'tdDVd'Dd4V4'd$V'dV'dV'dVt'TdVD'$dV'dV'dV'dV'ddVT'4dV$'dtV'ddV' dBtt,Tolk$]V8TV'Todk]V'TTo\k]VD'4TV$'ToTk]V'TtV'TdV'tTDVd'DT4V4'T$V'TV'TV'TVt'TTVD'$TV'TV'TV'TV'dTVT'4TV$'TtV'TdV'  TBtt, Dolk$]V8DV'Dodk]V'TDo\k]VD'4DV$'DoTk]V'DtV'DdV'tDTVd'DD4V4'D$V'DV'DV'DVt'TDVD'$DV'DV'DV'DV'dDVT'4DV$'DtV'DdV'p DBtt, 4olk$]V84V'4odk]V'T4o\k]VD'44V$'4oTk]V'4tV'4dV't4TVd'D4DV4'4$V'4V'4V'4Vt'T4VD'$4V'4V'4V'4V'd4VT'44V$'4tV'4dV' 4Btt, $olk$]V8$V'$odk]V'T$o\k]VD'4$V$'$oTk]V'$tV'$dV't$TVd'D$DV4'$4V'$V'$V'$Vt'T$VD'$$V'$V'$V'$V'd$VT'4$V$'$tV'$dV': $Btt, olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV' Btt, olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV' Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'i Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'! Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'3# Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'$ Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'% Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'b' Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'( Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV',* Btt,tolk$]V8tV'todk]V'Tto\k]VD'4tV$'toTk]V'ttV'tdV'ttTVd'DtDV4't4V't$V'tV'tVt'TtVD'$tV'tV'tV'tV'dtVT'4tV$'tV'tdV'+ tBtt,dolk$]V8dV'dodk]V'Tdo\k]VD'4dV$'doTk]V'dtV'ddV'tdTVd'DdDV4'd4V'd$V'dV'dVt'TdVD'$dV'dV'dV'dV'ddVT'4dV$'dV'dtV', dBtt,t<\4$ttddTD/H48TD4$tdD4tTD$dT4$YYYYYYYYYYYYYYYYYYYY0   XN(D %l@TFX%h$ h dT A)hT5KKl@k4%TFX%h$ h dT )hTKl@k4%TFX%h$ h dT )hTFl@l@TFX%h$ h dT )hT 9:X:]3M:X{]3&i @:D|%T:XL%h$ h dT%(%$ u)hT5  v!4LC`` dl Cll }P2l`K:X~]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3ci @:D%T:XL%h$ h dT%(%$ u)hT5  v^4LC`` dl Cll }P2l`K:X]3"i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l` :X@K:X]3ji @:D%T:XL%h$ h dT%(%$ u)hT5  ve4LC`` dl Cll }P2l`K:X]3)i @:D%T:XL%h$ h dT%(%$ u)hT5  v$4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3 i @:D%T:XL%h$ h dT%(%$ u)hT5  v 4LC`` dl Cll }P2l`K:X]3f i @:D%T:XL%h$ h dT%(%$ u)hT5  va 4LC`` dl Cll }P2l`K:X]3% i @:D%T:XL%h$ h dT%(%$ u)hT5  v 4LC`` dl Cll }P2l`K:X]3 i @:D%T:XL%h$ h dT%(%$ u)hT5  v 4LC`` dl Cll }P2l`K:X]3 i @:D%T:XL%h$ h dT%(%$ u)hT5  v 4LC`` dl Cll }P2l`K:X]3b i @:D%T:XL%h$ h dT%(%$ u)hT5  v] 4LC`` dl Cll }P2l`K:X]3!i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3^i @:D%T:XL%h$ h dT%(%$ u)hT5  vY4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3Zi @:D%T:XL%h$ h dT%(%$ u)hT5  vU4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3Vi @:D%T:XL%h$ h dT%(%$ u)hT5  vQ4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3Ri @:D%T:XL%h$ h dT%(%$ u)hT5  vM4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v 4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3i @:D%T:XL%h$ h dT%(%$ u)hT5  v4LC`` dl Cll }P2l`K:X]3Ki @:D%T:XL%h$ h dT%(%$ u)hT5  vI4LC`` dl Cll }P2l`:X:]@:Xy]@:Xy]@4LC`` dl Cll }P2l`%:Xy]/:Dy]<'04LC`` dl Cll }P2l`@:X]33 T  0O :XlLXHt0 lP@,l`hT00 P   0   8tTN(( %l@8F<%L$ L d8 A)L85Fl@l@8F<%L$ L d8 )L8(<"P (\lPi(h5(\(<" X\"lPR6@ k[ k`X k{8 k\"lPp\"lPcx'h\"lPXpH\"lP8c('6X8$  k\"lP35.(\(<" X6:<]3^>#*#*##*#*:#*#*##*#*: lP \TL8xhXH8(0 x   tTtLN( %l@0F4%D$ D d0 A)D05Fl@l@0F4%D$ D d0 )D0(4"H pppp(\lHi h5(\(4"x Xx\"lHR6x@ k[x k`H k{( k- k/ k: k\"lHp\"lHxch'X\"lHHp8\"lH(c'\"lH/\"lHp\"lHc'xh6xH(@ k[x k`H k{( k\"lHp\"lHxch'X\"lHHp8\"lH(c'6xH( oTtTN/ k:x k\"lHp\"lHxch'X6xA oLtL$- k\"lH35"\(4]/\/xp kp.(\(4"x XxX6X:4e]3p^>#T*#PE*#L#H*#DF*F:4Gx: h42 TPLHD6xpWM4p@(%0:4%D$ D d0 C)D05p뫜p :4p^>#T*#PE*#L#H*#DF*F:4Gx: h42 TPLHD6xpKM4p@(%0:4%D$ D d0 C)D05p뫜p :4 \~ oToL^>#T*#PE*#L#H*#DF*F:4Gx: h42 TPLHD6xpPM4p@(%0:4%D$ D d0 C)D05p뫜p :4 kkkk^>#T*#PE*#L#H*#DF*F:4Gx: h42 TPLHD6xpQM4p@(%0:4%D$ D d0 C)D05p뫜p :4:4]3 T0 :4lhX> lH]\X4hxTPLHDD0xhXH8(xhhtTN(( %l@8F<%L$ L d8 A)L85Fl@l@8F<%L$ L d8 )L8(<"P (\lPi(h(5(\(<" X\"lPR6N/ k: k\"lPp\"lPcx'h6n$. k\"lP353.(\(<" XX6 oTtTX:<]3<^>#*#*##*#*:#*#*##*#*:#*#*##*#*: lP\X4< TPLHDL8xh0   XN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H<]t^>#*#E*##*#F*F:HG:42 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T((0 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^>#*#E*##*#F*F:HG:4n2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T,,0 :Hl@(l\`8 XD`N(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^>#*#E*##*#F*F:HG:4o2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 :HPP:H]3 :Hl,D,l\P`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^>#*#E*##*#F*F:HG:4p2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T440 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^>#*#E*##*#F*F:HG:4q2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T880 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^>#*#E*##*#F*F:HG:4r2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T<<0 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^>#*#E*##*#F*F:HG:4s2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T@@0 :Hl@(l\`8 XDx tT c0@N( %l@(F0%,$ , d( A),(5Fl@l@(F0%,$ , d( ),(El@( %(F0%,$ , d( ),( (0]@ f0@"P !(\lPihx5(\(0"h Xh\"lPR6hN/ k:h k\"lPp\"lPhcX'H6h f0@ \~xR@f0]@~ +0]p ]c'hp ,(0'h h53(0 ]/ 9:]/h'X5k %(0 ]V(]c'h 9:0]35 f0@k %(0]V(]c'hfB 9:0]/h 9h:]/XH6hUa f0@k %(0]V(]c'h 9:0]35 f0@k %(0]V(]c'h 9:0]35 f0@k %(0]V(]c'hB 9:0]/h 9h:]/XH6h~ f0@k %(0]V(#]c'h 9:0]35 f0@k %(0$]V((]c'h` 9:0]/h 9h:]/XH8 98:]/(6h8nz f0@k %(0(]V(-]c'hB 9:0]/h 9h:]/XH6h f0@k %(0-]V(2]c'hO 9:0]/h 9hX X:]/H86hXq} f0@k %(02]V(6]c'h` 9:0]/h 9h:]/XH8 98:]/(6h8  f0@k %(08]V(<]c'hr 9:0]35am f0@k %(0<]V(A]c'hB 9:0]/h 9h:]/XH6h f0@k %(0C]V(F]c'h` 9:0]/h 9h:]/XH8 98:]/(6h8u f0@k %(0F]V(K]c'h ` 9:0]/h 9h:]/XH8 98:]/(6h8   f0@k %(0K]V(N]c'hv  9:0]35e q  f0@k %(0N]V(O]c'h B 9:0]/h 9h:]/XH6h   f0@k %(0O]V(P]c'h  9:0]/h 9h:]/XH8 98:]/( 9:]/ 9:]/ 9:]/xh6 h8   f0@k %(0P]V(V]c'h_ B 9:0]/h 9h:]/XH6hN Z  f0@k  f0@|  f0@@f0]3n ^>#d*#`E*#\#X*#TF*F:0Gh:XD2 d`\XT6hp MDp@(%(:0%,$ , d( C),(5p뫜p :044:0]3 T0 :0l%H \B lxP\@4Dld`\XT,(hXH8(xh0   |N(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H]@(H ]3:H}fH]3^>#*#E*##*#F*F:HG:4p`2 6pgM`p@($%D:H%X$ X dD C)XD5p뫜p :H@^>#*#E*##*#F*F:HG:4p`2 6pMM`p@($%D:H%X$ X dD C)XD5p뫜p :H@@:H]3 THH0 :Hl<H0 l\`@8 XDp(N(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD %(H]<(4 ]<'-ll C J:H]3/5 :H^>#*#E*##*#F*F:HG:4p2 6pzMpp@($%D:H%X$ X dD C)XD5p뫜p :H:H]3 TPP0 :Hl(@(l\p8 XDN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (H]@  WTl@l@DFH%X$ X dD  )XD5,:HN 5(H ]30 9( X6:HY]/:4Z]/:$[]/td:\]/TD:4]]/$:^]/:_]/:`]/:ta]/dT:Db]/4$:c]/:d]/:He((H":4e5>tt(H"d Xd6t(H]@^>#*#E*##*#F*Fp:HG:4ft`2 6p^M`p@($%D:H%X$ X dD C)XD5p뫜p :HPC g h gt26^>#*#E*##*#F*Fp:HG:4it`2 6pM`p@($%D:H%X$ X dD C)XD5p뫜p :HP^>#*#E*##*#F*Fp:HG:4ft`2 6phM`p@($%D:H%X$ X dD C)XD5p뫜p :HP^>#*#E*##*#F*Fp:HG:4ft`2 6pNM`p@($%D:H%X$ X dD C)XD5p뫜p :HP^>#*#E*##*#F*Fp:HG:4jt`2 6p4M`p@($%D:H%X$ X dD C)XD5p뫜p :HPP:H]3 TLL0 :Hl,\Dl\`pPXDtdTD$dT4$PN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (Hd]t^>#*#E*##*#F*F:HG:4r2 6p(Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 :HPP:H]3 :Hl,D,lP\`8 XDPN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (Hd]t^>#*#E*##*#F*F:HG:4r2 6p(Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 :HPP:H]3 :Hl,D,l\P`8 XDLN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (Hd]t^>#*#E*##*#F*F:HG:4r2 6p(Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T\\0 :Hl@(l\`8 XD$5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KFl@l@F\%H$ H d8 )Hi @:L%:\L%H$ H d8%(%$ u)H58  v_K^>#*#*##*#*8:Gﳢ:<,2 |xtpl68LpM,p@(%:\%H$ H d8 C)H58p뫜p :\:\]3{ T``0 :\l`H0 l\(,< |xtplH8L<      !">`$`$!`(I`a/0q` y0++<`y0++00<`y0++00$ ` $ `89 `y0++08a `y0++0$ `0` y0++0` y0++0` y0++0)` y0++0Q` y0++0y` y0++0` y0++0` y0++0 ` y0++01` y0++0Y` y0++0` y0++0` y0++0` y0++0` y0++0!` y0++0I` y0++0q` y0++0 ` y0++0!` y0++<"`y0++00n0* pHd VBAProject4@j = r V^ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files (x86)\Common \Microsoft Shared\OFFICE12\MSO.DLL#P 16 .0 Ob LibraryNMSFo@rms>SFrmHs3D452EE1-E08F1A-8-026(Validate3PCommandButton3_ClickFA(ClearWorksheet_Activate+Sheets Protectf Sheet2 Sheet3 Sheet4 Sheet5 Module1b(isValidateMandatoryr(isValidCountry (isValidState+(isValidDistrictނ(isValidInvTypenv (isAlphaNumeic(isAlphaNumeic1=E(isIndianPincode'y(isForgienPincodeh(isValidFolioNumber#(isValidDpIdClientIdAccountNop"(isValidInvestorFirstNameL(isValidInvestotMiddleName(isValidInvestorLastName%(isValidFatherHusbandFirstName(isValidFatherHusbandMiddleName(isValidFatherHusbandLastName^ (isNumeric1 (isValidPan(isValidDateOfBirthj(isValidAadharNumber(isValidNomineeNameLength(isValidJointHolderNameLength(isValidRemarksx(isValidInvLtgtn'&(isValidSharesFromUnpaidSuspenseAccount(rowCountu (errorCounter(isPrefillClickedP" isValidAll pisValidJointHolderNameJyisValidNomineeName (Remove_Spaces& Unprotect?Cells (getRowCount strCINTrim@Range strCompanyNamemValueKMsgBoxR WorksheetsPasswordUserInterfaceOnlyN(FindFirstBlankRow sumCalculatee (Calculate (ValidateAllvbOKOnlySumactErrHandlerCalcsumdiv{ Application*Sum rangeSheetW rangeTextRS_ SpecialCellsxlCellTypeConstantsW xlTextValues ClearContents{ ColNumberR colCounter rowCountereDataRow | fieldText fieldValueDisValid@N (validateInvestorMiddleNameLength.%(validateFatherHusbandMiddleNameLength (validatePanv((validateDateOfBirthS(validateAadharNumberj(validateNomineeName(validateJointHolderName~(validateRemarks (alphaNumerica countrynm)UCase5  (indianPincodeflag(foriegnPincode(validateMandatory]LastRowWithValue2FindnSearchDirectionr xlPrevious RowCurrRow (IsBlankRowRowsUmsgQresp vbQuestion vbOKCancelx?vbOK%IsBlanke,xoCount0v SheetDataL%errMsg (validateFolio (alphaNumeric1S(NumericQ(validateCountry#f(validDpIdClientIdAccountNo  (validateState districtName(validateDistrictP(validateInvestorFirstNameLength-(validateInvestorLastNameLength$(validateFatherHusbandFirstNameLength#(validateFatherHusbandLastNameLengthҌ(validateYesorNohvIsDate2cc\ff9]gg_] vbTextCompare Qhh]ii] DateValue/Now%isForiegnPincodeisValidInvestorMiddleName SheetListp}DataListHListRow9ListColColumni countryNamek conNameChkzMatchRIsErra  (*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.6#0#C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE#Microsoft Excel 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.4#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 16.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{6F5DB33B-3C2D-4CA9-8E6C-4765464E927D}#2.0#0#C:\Users\ramasamy\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{3050F1C5-98B5-11CF-BB82-00AA00BDCE0B}#4.0#0#C:\Windows\SysWOW64\mshtml.tlb#Microsoft HTML Object Library*\G{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}#1.1#0#C:\Windows\SysWOW64\ieframe.dll#Microsoft Internet Controls*\G{F5078F18-C551-11D3-89B9-0000F81FE221}#3.0#0#C:\Windows\SysWOW64\msxml3.dll#Microsoft XML, v3.0  V^ThisWorkbook01639353e2ThisWorkbookf5 Sheet10<63935439 Sheet1U& Sheet20=6393543a3 Sheet20 Sheet30>6393543a5 Sheet3H Sheet405639353e27 Sheet4;`Y Sheet506639353e29 Sheet5Vx5Module10;639353f3:Module1|'`x0H}=|ZJLts<k\PL˸i`arrAlNum fieldNameLengthYChrK~nextvalKacounterncounterspecialCharFlagohypCountE consecutiveFlagu  firstLastHyp (validFolioNO_ validFlagJustatefieldValue~IsPAN fieldValue2invLtgtnE invLtgtnCheckCommandButton1|CommandButton2}CommandButton3~Workbookk WorksheetClickActivate|_B_var_isValidAllu_B_var_isValidJointHolderNameT_B_var_isValidNomineeName _Defaultj _B_var_TrimmT _B_var_strCIN j_B_var_strCompanyName>_B_var_sumCalculate_B_var_rowColumn2_B_var_rowColumn5_B_var_rowColumn7_B_var_rowColumn8_B_var_rowColumn9_B_var_rowColumn10_B_var_rowColumn11_B_var_rowColumn12_B_var_rowColumn13_B_var_rowColumn14_B_var_rowColumn15_B_var_rowColumn16_B_var_rowColumn17_B_var_rowColumn18_B_var_rowColumn19_B_var_rowColumn20_B_var_rowColumn21_B_var_rowColumn22_B_var_rowColumn23_B_var_rowColumn24_B_var_CurrRow _B_var_msgbr _B_var_resp! _B_var_sumdiv$_B_var_DataRow_B_var_fieldText _B_var_fieldValue\_B_var_isValidCB_B_var_countrynm3 _B_var_UCasea _B_var_flagc_B_var_districtNameX _B_var_cco _B_var_Midp _B_var_ff _B_var_gg _B_var_hh- _B_var_iiS_B_var_isForiegnPincode> _B_var_isValidInvestorMiddleName_B_var_fieldName" _B_var_Length> _B_var_Chr\;_B_var_nextval O_B_var_strNameN_B_var_ListRowl=_B_var_ListColj_B_var_countryName_B_var_conNameChkY_B_var_stateName_B_var_stateNameChk +_B_var_countryMatch{%_B_var_statefieldValuew _B_var_LeftQ _B_var_IsPAN _B_var_errMsg`? _B_var_Format_B_var_fieldValue2_B_var_invLtgtng_B_var_invLtgtnCheck 3579;  ~mF`(0!qUadir__SRP_0-__SRP_1 PROJECTwm08C4 D0BB4TFMl20L'B @a&/;"1lrAr00}#0rF# 0@6F5DB33B-3C2D-4CA9-8E6C-476546@4E927DH.U sers\`asamy\AppData\Local\Temp\Excel8.0\0.exd]5#.E .`M ̃MSHTM LM@aHTMLv lA33050F1C5-98B5-11CF-BB82BDCE0B}#4mshtmlBljSHDocVwSHDBcVwukEAB22AC0-30C1A7EBb5 C05BA1."1nief/e.dll*Internet Controls @&PXML2&Xb&2!&b&F5078F18-C55D3-89B9F81FE2 21}#3&xml3, v @ThisWorkbookGT@i`kW(rkbo2` 115,"a,fR"+S@heet1G Set1M2  U& 2 2 2 42 ހU 3 3 3 3S ) 4 4U 4 4 Y; 5 5 5 f5 EV oduleFoPwuRw!#2d _'^*|!X*rU~~~y   CurrRow SheetData rowCounter colCounter SheetListDataList DataColumn y Details RangeText G2   Value Please enter CINPassword "UserInterfaceOnlyProtect 6Please Prefill Company Name Stop 2Error! Please refer Error @Invalid data present at row no:: 2 .Kindly refer ErrorSheetaVBE6.DLL   S ( A15:O65536FFL=G)Z@ͣ[B}6eY?oHX @EndRow * : pBlank Rows Found.Do you want to Clear Rows from row no.   to  ??? *Deletion ConfirmationClearContents A1 O10:OSum INDIA  x *Error at line number  \ column 1 or 3 (Investor First or Last Name) $ : Mandatory Field l column 4 or 6 (Father/Husband's First or Last Name)  p column 10 or 11 either District or Pincode is mandatory  Column  West Bengal$ Either Folio Number or DP Id-Client Id-Account Number is mandatory  column  ( ) Sheet3 A2 InvestmentLtgtn JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC - MEGHALAYA , : Invalid Date Format f : should be less than or equal to the system date.  : Invalid Date -  x    "  $Dadar Nagar Haveli Uttarakhand b : More than one consecutive space is not allowed r : Special Characters and Numeric Values are not allowed. ` $ : Investor First Name Should be Less Than or equal to 35 Characters Chandigarh Chhattisgarh$ : Investor Middle Name Should be Less Than or equal to 35 Characters# : Investor Last Name Should bK*rU ~~~~~~~~~~ ~~~~~~~~~~~~~~~~ .J>Y   a  Aya y)a yA Y qa # 9 Y  9 Q i ! a AAi 9iAYiyiI )  VBAProject ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Module1F /C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  10F:C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXEExcel A@0F Prefill_WS1C:\Windows\SysWOW64\stdole2.tlbstdole  QPL-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice `.E .`M C:\Windows\SysWOW64\FM20.DLLMSForms apr6EB4ݦ9C:\Users\ramasamy\AppData\Local\Temp\Excel8.0\MSForms.exd aP0 C:\Windows\SysWOW64\mshtml.tlbMSHTML  Q*0[ C:\Windows\SysWOW64\ieframe.dllSHDocVw 1 Q!C:\Windows\SysWOW64\msxml3.dllMSXML2   Validate Calculate Remove_Spaces ValidateAllFindFirstBlankRow IsBlankRowvalidateMandatoryvalidateCountry validateState getRowCountvalidateDistricterrorClear alphaNumeric validateFolio alphaNumeric1Numeric validFolioNOvalidDpIdClientIdAccountNovalidateInvestorFirstNameLength  validateInvestorMiddleNameLengthvalidateInvestorLastNameLength $validateFatherHusbandFirstNameLength %validateFatherHusbandMiddleNameLength #validateFatherHusbandLastNameLength indianPincodeforiegnPincode validatePanvalidateAadharNumbervalidateDateOfBirthvalidateNomineeNamevalidateJointHolderNamevalidateRemarksvalidateYesorNo tt  $(,048<@DHLPTX\`dF& 2חF V?H FQ OVL6{lFWJOCommandButton1@2iwThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5Module1Module1ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H000PROJECT KSummaryInformation("$DocumentSummaryInformation8(8 CompObj Ur00000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Module=Module1 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="96943AEA4E3EFC42FC42F947F947" DPB="4042ECF309F3090CF7F4093F9F6243375D5ED1EC6C9B70522A76805466F68CAE81B493F3" GC="EAE8463EF13FF13FF1" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=130, 130, 1024, 571, Z Sheet2=182, 182, 1076, 623, Sheet3=208, 208, 1102, 649, Z Sheet4=156, 156, 1050, 597, Sheet5=26, 26, 920, 467, C Module1=52, 52, 946, 493, Z Oh+'0@Hdx Natasha Bhagwani AMIT KUMARMicrosoft Excel@@;XXM՜.+,D՜.+,t0 PXp x Infosys Limited 7Read MeInvestor DetailsErrorSheet3Country_State_District_MappingAndamanandNicobarIslandsAndhraPradeshArunachalPradeshAssamBihar Chandigarh ChhattisgarhCountryDadarNagarHaveli DamanandDiuDelhiGoaGujaratHaryanaHimachalPradeshIndiaInvestment_LitigationInvestmentLitigatioInvestmentLitigationInvestmentLtgInvestmentTypeJammuandKashmir Jharkhand KarnatakaKerala LakshadweepMadhyaPradesh MaharashtraManipur MeghalayaMizoramNA NagalandOrissa PondicherryPunjab Rajasthansfsfusa%shares_from_unpaind_suspense_account sharesfusaSikkimsssss TamilNadu TelanganaTripura Uttarakhand UttarPradesh WestBengal  Worksheets Named Ranges2!5e y    )Y8MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Enabled7MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_SiteId6MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Owner8MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_SetDate5MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Name<MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_ApplicationEMSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Extended_MSFT_Method 8MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Enabled 7MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_SiteId 6MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Owner 8MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_SetDate 5MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Name<MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Application7MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_ParentEMSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Extended_MSFT_Method SensitivityTrue(63ce7d59-2f3e-42cd-a8cc-be764cff5eb6$saisrinivas.bollina@ad.infosys.com 2019-02-25T07:10:45.2162424Z Internal(Microsoft Azure Information Protection AutomaticTrue(63ce7d59-2f3e-42cd-a8cc-be764cff5eb6$saisrinivas.bollina@ad.infosys.com 2019-02-25T07:10:45.2162424ZCompanywide usage(Microsoft Azure Information Protection(be4b3411-284d-4d31-bd4f-bc13ef7f1fd6 AutomaticInternal Companywide usage F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89q